PL/SQL CLOB

[Patrick Neumann]

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

[Frank van Bortel]

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

[Taurus]

>
> 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