Re: Array of string

Whoops - that should have read "...PL/SQL type, not a real 'table') of VARCHAR2's"
(i.e. 'of' not 'or')

Steve Phelan.

Steve Phelan wrote in message
<889099539.27294.0.nnrp-09.c2de712e_at_news.demon.co.uk>...
>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