Translating Oracle Package Call from ADO to ADO.Net

Discussion in 'ASP .Net' started by dmiratsky@yahoo.com, Feb 14, 2005.

  1. Guest

    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?
     
    , Feb 14, 2005
    #1
    1. Advertisements

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

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Matrix
    Replies:
    0
    Views:
    700
    Matrix
    Apr 1, 2004
  2. nita
    Replies:
    1
    Views:
    1,065
    Saravana
    Nov 20, 2004
  3. Craig G

    passing Oracle Nulls in ADO.NET

    Craig G, Dec 16, 2004, in forum: ASP .Net
    Replies:
    1
    Views:
    622
    Craig G
    Dec 16, 2004
  4. ronaldlee

    Transfer ADO Code to ADO.NET

    ronaldlee, Dec 17, 2004, in forum: ASP .Net
    Replies:
    1
    Views:
    645
    Kevin Spencer
    Dec 17, 2004
  5. =?Utf-8?B?U2hpanUgUG95aWxpbA==?=

    BULK INSERT WITH ADO.NET & ORACLE

    =?Utf-8?B?U2hpanUgUG95aWxpbA==?=, Apr 25, 2005, in forum: ASP .Net
    Replies:
    2
    Views:
    6,576
    Sathya.Pai
    Sep 9, 2009
  6. jobs
    Replies:
    0
    Views:
    980
  7. Navin
    Replies:
    1
    Views:
    1,136
    Ken Schaefer
    Sep 9, 2003
  8. Feyruz
    Replies:
    4
    Views:
    3,106
    Sherm Pendley
    Oct 14, 2005
Loading...