Reputation: 413
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.
Upvotes: 1
Views: 1286
Reputation: 6021
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.
Upvotes: 1