L
L
Light7772020-07-12 13:37:26
C++ / C#
Light777, 2020-07-12 13:37:26

How to pass c# object to oracle database?

In basis oracle there will be a procedure for reception of object (oracle type).
How can I pass an object to an oracle procedure using C#?

There is a code example for passing one parameter, but my object has 10 parameters and I would like to know how to do it correctly without shit code

var con = new OracleConnection("connection string");
var com = con.CreateCommand("create_user");
com.Parameters.Add("i_user_name", OracleDbType.Varchar2, userName, ParameterDirection.Input);

Answer the question

In order to leave comments, you need to log in

1 answer(s)
L
Light 777, 2020-07-20
@Light777

Used UDT. Found the answer on Stackoverflow.
If anyone needs
here

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question