Translating Oracle Package Call from ADO to ADO.Net

D

dmiratsky

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
ADO.Net?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,968
Messages
2,570,150
Members
46,697
Latest member
AugustNabo

Latest Threads

Top