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

01-30-08, 02:15 PM

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?

01-30-08, 02:30 PM

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-collecti...red-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.

01-30-08, 02:36 PM

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.
"Nicholas Paldino [.NET/C# MVP]" wrote:
[..]

Similar Threads
transfer data to oracle by using Microsoft ODBC drive for oracle Hi, One dts would transfer data from SQL to oracle by using Microsoft ODBC drive for oracle. After start the job, the oracle won't see any record transferred 20 minutes...
Passing an array to Oracle procedure's parameter Hello. Is there any way to pass an array to an Oracle procedure's parameter? (I am using System.Data.OracleClient classes). Thanks in advance. Celio C. J.
How to pass array as parameter from VB to a Stored Procedure in Oracle I have written a stored procedure in Oracle which accepts a varray as IN parameter. I need to execute this procedure from VB using ADO. How will I declare this array in...
Sending array as parameter to Oracle DB Function Hi! I try to send array(table of records) as parameter to Oracle DB Function\Procedure from VB program through ADO connection. Can I do this operation? If so what is the...