Calling Oracle SP with RowType as Input Parameter

anandss

New member
Joined
Jul 19, 2004
Messages
1
Programming Experience
10+
Hi,
I am trying to call an Oracle SP that uses ROWTYPE as input parameter. I am using VB.NET to try this.
Does anybody know how to make a call to SP like this. I could not find any help searching on the Internet.


Procedure UpdateSubscriber
(p_SUBROW IN PPS_SUBSCRIBER%rowtype
, p_info in subscriber_info%rowtype
, p_home in subscriber_home%rowtype
, p_phonebook subs_phonebook%rowtype
, p_periodic_chg sub_periodic_chg%rowtype
, return_code out integer
, return_msg OUT VARCHAR2 )
is

I have some other procedures that return Cursor type where I have used OracleDataReader to get it. Is rowtype and cursor type are same.
Moreover oracle client for .NET supports OracleClient.Cursor whereas I do not see anything like rowtype.

Any help is appreciated.


Thanks and Regards,
Anand

 
Last edited:
Top Bottom