passing Associative Arrays to oracle SP from c#

Question

Can some one please tell me how to send a Associative Array as a parameter to

a oracle stored procedure from c#......I am using  System.Data.OracleClient

....please give your suggestions its urgent.....

 

Thanks.

Answer 1

Hello Kay,

 

I looking for the same thing. Please, let me know if you have already found a solution.

 

Thanks,
Darcy

Answer 2

Something like the example in http://www.timvw.be/using-a-collection-as-parameter-for-a-stored-procedure/ ?

Answer 3

Ok, that works if the associative array is of a primitive type, like NUMBER. But what if the associative array is of a RECORD type defined in the package? Anyone can help me???? I am trying to do this but still don't know how...

 

Cheers,

 

Gabriel Feldman

 

Answer 4

If you are using ODP.NET try the link below for existing code from Oracle, the problem comes from the Oracle associative array and the .NET associative array are not the same.  Oracle promised to fix it but just provided support in ODP.NET.

 

http://www.oracle.com/technology/oramag/oracle/07-jan/o17odp.html

 

Answer 5

Hi,

 

I have seen this link before, but it uses primitive types in the array.

 

My question is if I have a procedure in Oracle that receive a parameter of type MyArray where MyArray is defined as follows:

 

TYPE MyRecord IS RECORD (FieldA NUMBER, FieldB NUMBER);
TYPE MyArray IS TABLE OF MyRecord INDEX BY BINARY_INTEGER;

 

How can I invoke from C# a procedure that has an argument of type MyArray defined above? After looking for a while on the web and trying by myself I am quite sure now there is no support at all in .Net to invoke such a procedure... Please let me know if I am wrong!!

 

Thank you,

 

Gabriel Feldman

 

 

 

Answer 6

So you are not looking for data access code but more like native C# in Oracle, I don't think that is what Oracle or Microsoft want you to do.

Answer 7

Did You got solution for this if Yes please post it

I am getting same problem.

I have VARRAY of type Object and need to pass value from c#

Answer 8

Hi,

Did you find any way to pass custom type using ODP.Net?


Like the example that you shared earlier....
TYPE MyRecord IS RECORD (FieldA NUMBER, FieldB NUMBER);
TYPE MyArray IS TABLE OF MyRecord INDEX BY BINARY_INTEGER;

 

I am also trying to do the same thing but not able to find out how to do this.

Answer 9

The Microsoft OracleClient C# driver does not have support for tables or record or arrays.
I would check with Oracle to see if their NDP driver supports this.

Answer 10

OPD.Net provides method to pass User Defined Data Type (UDT) and arrays too...Have a look at the following article it may help you

 http://www.oracle.com/technology/oramag/oracle/08-may/o38net.html

Answer 11

Yes ODP.NET provides this functionality to pass .NET objects. More on this topic at the following link...

http://appsjack.blogspot.com/2010/09/pass-custom-udt-types-to-oracle-stored.html

Let me know if this helps.

Answer 12

This is Tutorial that you are looking for.

http://www.magic-dev.com/map-udt-asp-net-oracle.htm