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