Re: Passing input parameter > 4000 characters

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.