Re: Passing input parameter > 4000 characters

You should also look at the PL/SQL User's Guide and Reference, specifically the datatype section and note that the PL/SQL varchar2 is a max of 32767 bytes.

regards,
cindy

Ron Reidy wrote:

> gunjeet singh wrote:
> >
> > Hi All,
> >
> > I have a stored procedure that takes a set of comma separated record ids
> > as input.
> > The procedure accepts a varchar2 as input parameter. We have now found
> > out that the id list can exceed 4000 characters. How do I pass this
> > parameter from Java to pl/sql
> > procedure ?
> >
> > Inside the procedure, I need to parse this comma separated list of
> > values and
> > populate a global temporary table. The final query is executed against
> > the ids stored in this global temporary table.
> >
> > How can this be done ? CLOB datatype ? Any examples ?
> >
> > Thanks,
> >
> > Gunjeet
> Change your SP to accept a PL/SQL table.
> --
> Ron Reidy
> Oracle DBA
> Reidy Consulting, L.L.C.
Received on Fri Dec 14 2001 - 17:58:37 CST