Re: Array of string

Well, I suppose your 'array of string' would translate to a TABLE (that's a PL/SQL type, not a real 'table') or VARCHAR2's. You could write a PL/SQL function to gather data from this table which you could call from your SQL statement. Not sure whether you'd have to use DBMS_SQL to maybe parse the result from this function (a varchar2 of concatenated values separated by commas?) into your SQL statement. Experiment a little - that's where the fun (and the learning) is! :-)

Having said all that, you might be better off just pushing the stuff into a 'real' temporary table and just sub-selecting from it in your main SQL statement. Much easier to code and maintain, and it *might* even end up faster.

Just my quick thoughts...

Steve Phelan.

Navoni Massimo wrote in message <34FADFE8.FFBE0E83_at_esa-group.it>...
>Does anyone know if it's possible to declare an array of string in an
>oracle stored procedure, and use this array as argument of the 'IN'
>operator in a 'WHERE' clause of the same stored procedure ?
>
>Thanks
>
Received on Thu Mar 05 1998 - 00:00:00 CST