Re: send chunk of data

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: