Oracle stored procedures in connections

Home Forum General Oracle stored procedures in connections

This topic contains 1 reply, has 0 voices, and was last updated by  pointreyes 9 years ago.

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #352

    pointreyes
    Participant

    What does it take to get a procedure in Oracle to return a result set through the connection? I have a procedure that is successful in Oracle but fails through the connection with the error:

    ERROR: Agent SQL error ORA-06550: line 1, column 7:

    PLS-00306: wrong number or types of arguments in call to ‘FIND_EMPLOYEE_NONCASE’

    ORA-06550: line 1, column 7:

    PL/SQL: Statement ignored

    I get this error no matter what I have in the send parameters.

    #4909

    ijobling
    Participant

    This error would indicate that your stored procedure itself is the problem

    I can see by ‘googling’ your error (PLS-00306: wrong number or types of arguments in call ) a number of similar issues on the web. One I see comments:

    While calling procedure which uses type/collection as argument we should use the type declared in the package itself and not locally declared type of similar type.Because separate types defined in PL/SQL are not considered to be the same type, even if they are identical.So when I used varaible of type of package it worked.

    If it isn’t this, perhaps ‘google’ the error to see other possible reasons for your problem

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.