nileshcssi
Programmer
I am trying to use an object that looks something like this (trimmed for brevity's sake):
CREATE OR REPLACE TYPE t_operator AS OBJECT(
login_name VARCHAR2(47),
initials VARCHAR2(4),
user_password VARCHAR2(40),
restriction_level NUMBER(1));
With a stored procedure contained in a package. Here is a relevant excerpt:
FUNCTION get_operator(
p_operator IN OUT t_operator
)
RETURN INTEGER IS
I am trying to use ODP.NET (Oracle Data Provider) in C# to call this stored procedure, passing all of the data in for p_operator, and then reading it back after the procedure has executed. I don't know how to approach this situation, or if its even possible with ODP.NET. I have tried to use an Associative Array, but I don't know if that applies, or how I'd use it if it does apply.
Any information would be appreciated. I am using the ODP 9.2.0.4.0 Beta. If this is possible in C# with something other than ODP.NET, I'd be interested in that as well. Thanks!
CREATE OR REPLACE TYPE t_operator AS OBJECT(
login_name VARCHAR2(47),
initials VARCHAR2(4),
user_password VARCHAR2(40),
restriction_level NUMBER(1));
With a stored procedure contained in a package. Here is a relevant excerpt:
FUNCTION get_operator(
p_operator IN OUT t_operator
)
RETURN INTEGER IS
I am trying to use ODP.NET (Oracle Data Provider) in C# to call this stored procedure, passing all of the data in for p_operator, and then reading it back after the procedure has executed. I don't know how to approach this situation, or if its even possible with ODP.NET. I have tried to use an Associative Array, but I don't know if that applies, or how I'd use it if it does apply.
Any information would be appreciated. I am using the ODP 9.2.0.4.0 Beta. If this is possible in C# with something other than ODP.NET, I'd be interested in that as well. Thanks!