Re: Passing input parameter > 4000 characters

And wait until parameter length will exceed 32767? And than ask the same question again?
I vote for better design!
Regards

"C. Ferguson" wrote:

> 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 Mon Dec 17 2001 - 03:30:48 CST