Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Passing an object to a stored procedure using Oracle Data Provider?

Status
Not open for further replies.

nileshcssi

Programmer
Apr 22, 2003
6
MX
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!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top