inlokesh
inlokesh

Reputation: 413

How to pass name value pair to Oracle from .NET

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

Answers (1)

Andrea Colleoni
Andrea Colleoni

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

Related Questions