I need to pass name value pairs containing column name and column values of table to Oracle from c#.net. How can I do this?, I did take a look at this http://my-tech-talk.blogspot.com/2010/01/how-to-pass-arrays-from-net-c-to-oracle.html not sure whether I can use this for two dimensional array.
Asked
Active
Viewed 1,262 times
1 Answers
1
You can use JSON as a mediator between C# and Oracle.
For your name/value pairs you can use a Dictionary.
Take a look at here for PL/SQL and JSON and here for C# dictionaries and JSON.

Community
- 1
- 1

Andrea Colleoni
- 5,919
- 3
- 30
- 49
-
Length of varchar2 is limited to 4/32K in plsql, so this is not scalable solution for my problem. – inlokesh Nov 17 '11 at 16:55