How to pass a list to an stored procedure?

Can someone have an idea how to pass a list of values to an stored procedure.
I want to do somthing like this:

listOfCodes is a list of strings ie. ('abc','cdf',...) TYPE OutCursor IS REF CURSOR;

PROCEDURE mysproc (listOfCodes ????, o_RefCursor OutCursor) IS
...
...

BEGIN
...

   SELECT * INTO o_RefCursor FROM tables

      WHERE id IN (listOfCodes) ;
....

END; Any help is greatly appreciated.

Thanks. Received on Tue Apr 24 2001 - 03:29:26 CEST