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!

ArgumentException was unhandled by user code

840782Feb 17 2011 — edited Feb 26 2011

Hi,
I am a new user of ODP.net and Oracle. I have a stored procedure whose in parameter is UDT. It is a table of type Object. I need to know what would be its equivalent in .Net?

E.g.

create or replace
TYPE TEMP_OBJ AS OBJECT (
a_id number,
Name varchar2(256),
flag char(1),
user varchar2(256) )

create or replace
type ACTUALONE is table of TEMP_OBJ

procedure submit_proc
(i_actual in actualone,
o_status out number,
o_err_message out varchar2);

How do I map my oracle fields with the C#.Net. What do I do to execute the above stored procedure i.e. "submit_proc" from my .Net code? I want a code or explanation on how to ride on this beast.

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 26 2011

Added on Feb 17 2011

#odp-net

4 comments

293 views