Skip to Main Content

ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Passing an object to a stored procedure from C#?

403986Sep 16 2003 — edited Sep 17 2003
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 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 attempted 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 9.2.0.4.0 Beta. If this is possible with something other than ODP.NET, I'd be interested in that as well. Thanks!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 15 2003
Added on Sep 16 2003
1 comment
309 views