Re: Input array string

From: roger <rsr_at_rogerware.com>
Date: Tue, 27 Jan 2004 23:55:26 GMT
Message-ID: <Xns947DA289077AArsrrogerwarecom@204.127.204.17>

Daniel Morgan <damorgan_at_x.washington.edu> wrote in news:1075246331.458507_at_yasure:

> roger wrote:
>

>> That's a handy reference page with some interesting info.
>> Unfortunately, it doesn't address the question the poster is asking.
>> 
>> He is saying that he's got some application with an array of
>> values that he wishes to pass to a stored procedure, for use
>> in an SQL statement IN clause.
>> 
>> Nothing about using the InStrTab table type is going to help
>> him to pass those values to the stored procedure.

>
> That is a long way from saying you can't pass an array to a stored
> procedure: You can:
>
> http://asktom.oracle.com/pls/ask/f?p=4950:8:4392192797026934757::NO::F4
> 950_P8_DISPLAYID,F4950_P8_CRITERIA:208012348074,
>

Yes. I agree. You can pass an array to a PL/SQL procedure *from another PL/SQL procedure*

And the sample you reference above demonstrates that just fine.

What it doesn't attempt to show is how one would invoke that stored procedure *from a host application* which is, I think, the underlying problem the original poster was asking about.

I believe it might be possible if you use OCI and OTTI, but forget it with .NET and I suspect JDBC.

Come to think of it - I'm not sure about JDBC, I haven't used it in a long time.

Anyone know if that would work out? Received on Tue Jan 27 2004 - 17:55:26 CST