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_at_gmail.com> 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_at_gmail.com> 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