Re: send chunk of data

when I use CLOB as input parameter when I run the store procedure I
get the following error:

ORA-22297: warning: Open LOBs exist at transaction commit time
ORA-06512: at line 10


On Wed, 22 Dec 2004 15:47:45 -0500, rjamya <rjamya@xxxxxxxxx> wrote:
> why can't you use clob as the input parameter? if you use varchar2,
> you are limited to 32767 bytes.
> 
> Raj
> 
> 
> On Wed, 22 Dec 2004 12:18:13 -0800, hamid alavi <alavihamid@xxxxxxxxx> wrote:
> > List,
> >
> > I have a store procedure which have two input parameters one is
> > varchar2 and  I want to send 250K as a parameter to this store
> > procedure which will store as clob, my question is is there any
> > limitation size for sending a parameter to store procedure  or any
> > size we could send as varcah2 as an input parameter.
> >
> > Thanks,'
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
> 
> 
> --
> ------------------------------
> select standard_disclaimer from company_requirements where category =
> 'MANDATORY';
>
--
http://www.freelists.org/webpage/oracle-l

Other related posts: