Question about Passing Arrays to PLSQL

How can a PLSQL function receive an incoming list and use that list in an SQL statement?

E.g., I'd like a PLSQL function to execute an sql such as:

   select * articles where area in (list_in);

where list_in would look like

     "finance, technology, cooking"

(The calling java program would pass in list_in)

I know I can build a statement using dynamic sql, but I'd like to avoid the extra parsing overhead.

Any suggestions? For you java-folks, can I use a java.sql.types.array?

tnanks in advance.

bill milbratz

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Apr 13 2000 - 00:00:00 CDT