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

Patrick Neumann wrote:
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

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