Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > Translating Oracle Package Call from ADO to ADO.Net

Thread Tools

Translating Oracle Package Call from ADO to ADO.Net
Posts: n/a
This is what my Oracle Package Call looked like in ADO:

strSQL = "{call StkhldrPkg.GetEmployerProfileRS(" & ind_stakeID & ",
(resultset 0, pv_result))}"

I am a SQL Server guy, so I cannot for the life of me figure out how to
translate this into ADO.Net using the OracleClient. I am not sure how
many parameters this statement equates to in Oracle cause I keep
getting the following error:

ORA-06550: line 1, column 7: PLS-00306: wrong number or types of
arguments in call to 'GETEMPLOYERPROFILERS' ORA-06550: line 1, column
7: PL/SQL: Statement ignored

I've read several other discussions, but none of them seem to be exact
enough for my needs. Can anyone help me translate this quickly into

Reply With Quote

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
install_driver(Oracle) failed: Can't load 'C:/Perl/site/lib/auto/DBD/Oracle/Oracle.dll' for module DBD::Oracle: load_file:The specified procedure could not be found at C:/Perl/lib/ line 230. Feyruz Perl Misc 4 10-14-2005 06:47 PM
Transfer ADO Code to ADO.NET ronaldlee ASP .Net 1 12-17-2004 04:08 PM
Accessing an ADO Recordset or Record from ADO.NET nita ASP .Net 1 11-20-2004 07:06 AM
How i set this resultset size for call oracle package? Matrix ASP .Net 0 04-01-2004 06:38 AM
Ado sort error-Ado Sort -Relate, Compute By, or Sort operations cannot be done on column(s) whose key length is unknown or exceeds 10 KB. Navin ASP General 1 09-09-2003 07:16 AM