How to pass name value pair to Oracle from .NET

Question

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.

score 1 · Accepted Answer · edited May 23 '17 at 11:55

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.

edited May 23 '17 at 11:55

Community

answered Nov 17 '11 at 16:19

Andrea Colleoni

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

1 Answers1