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
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: