Re: PL/SQL CLOB

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