How to send an array as a parameter to Oracle using Microsoft's Da

[Susan]

I have a stored procedure that has, as an input parameter, a associative
array. I know how to send the parameter using ODP.Net, but I am trying to get
it to work with Microsoft's Data Provider. Any ideas? Also, does anyone know
how to do it with Java?

 

[Nicholas Paldino [.NET/C# MVP]]

Sysan,

I believe that this willd o what you want with MS's Oracle data
provider:

http://www.timvw.be/using-a-collection-as-parameter-for-a-stored-procedure/

As for doing it in Java, you might get a response here, but you might
want to repost this question (a Java-specific one) in a Java newsgroup where
it might get more people knowledgable on the subject.

 

[Susan]

Actually, that uses Oracle's ODP.Net. We are having problems with ODP and I'm
hoping that Microsoft's DP will not have the same issue.

Susan

P.S. The Java part was just because someone had the idea that we would not
get the error if we had a java web service calling the stored procs that I
then called.

Sysan,

I believe that this willd o what you want with MS's Oracle data
provider:

http://www.timvw.be/using-a-collection-as-parameter-for-a-stored-procedure/

As for doing it in Java, you might get a response here, but you might
want to repost this question (a Java-specific one) in a Java newsgroup where
it might get more people knowledgable on the subject.


--
- Nicholas Paldino [.NET/C# MVP]
- (e-mail address removed)

I have a stored procedure that has, as an input parameter, a associative
array. I know how to send the parameter using ODP.Net, but I am trying to
get
it to work with Microsoft's Data Provider. Any ideas? Also, does anyone
know
how to do it with Java?