| Computers Forum Index » Computer - Databases - Oracle (Tools) » PL/SQL CLOB... |
|
Page 1 of 1 |
|
| Author |
Message |
| Patrick Neumann... |
 Posted: Sat Aug 29, 2009 6:38 pm |
|
|
|
Guest
|
Hi,
I'am trying to assign a CLOB more than 32k within a stored procedure
under Oracle 9i.
Unfortunately CLOB seems to be limited to 32k. Search already metalink,
web etc but did
not get a clue how to worksaoround.
Anyone who has a workaournd/solution?
Thanks,
Patrick |
|
|
| Back to top |
|
|
|
| Frank van Bortel... |
| Posted: Sun Aug 30, 2009 3:27 pm |
|
|
|
Guest
|
Patrick Neumann wrote:
Quote: Hi,
I'am trying to assign a CLOB more than 32k within a stored procedure
under Oracle 9i.
Unfortunately CLOB seems to be limited to 32k. Search already metalink,
web etc but did
not get a clue how to worksaoround.
Anyone who has a workaournd/solution?
Thanks,
Patrick
A clob is a clob... not limited on 32k. With or
without a package.
I suspect you assign it to a varcghar2 variable.
That can extend from 4k in the db to 32k in PL/SQL
Show the code.
--
Regards,
Frank van Bortel |
|
|
| Back to top |
|
|
|
| Taurus... |
| Posted: Wed Sep 02, 2009 7:26 am |
|
|
|
Guest
|
Quote:
A clob is a clob... not limited on 32k. With or
without a package.
I suspect you assign it to a varcghar2 variable.
That can extend from 4k in the db to 32k in PL/SQL
Show the code.
Thanks for answering,
I forced assignments to clob only and got over it.
Afterwards next issue occurs while utml_stmp.write_data but writing
clob in chunks works.
BR,
Patrick |
|
|
| Back to top |
|
|
|
|
