Re: Question about Passing Arrays to PLSQL

I looked very hard to find the answer for this myself. Unfortunately, this is not easy as you will have to use some build in parse function to be able to do this. I don't think there is any other way as I have tried every other way without success.

Better off using a client-side dynamic SQL statement.

Dan

On Thu, 13 Apr 2000 23:04:25 GMT, billmil_at_my-deja.com wrote:

>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 20 2000 - 00:00:00 CDT