Re: Passing input parameter > 4000 characters

Cannot remember the exact Oracle version but there was a 4000 character limit on a VARCHAR2 parameter size.

The 32767 limit applies to a normal VARCHAR2 variable (as opposed to an input parameter). Again, it was Oracle version dependant.

M

"C. Ferguson" <c_ferguson_at_rationalconcepts.com> wrote in message news:<3C1A9274.D9303CF2_at_rationalconcepts.com>...
> 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 - 04:47:52 CST