Passing input parameter > 4000 characters

From: gunjeet singh <gunjeet.singh_at_eng.sun.com>
Date: Fri, 14 Dec 2001 14:00:00 -0800
Message-ID: <3C1A7660.8FA94401@eng.sun.com>

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 Received on Fri Dec 14 2001 - 16:00:00 CST