Getting unex err PLS-00306: wrong number or types of arguments in call to <Procedure>
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Getting unex err PLS-00306: wrong number or types of arguments in call to <Procedure>

Hybrid View

  1. #1
    Join Date
    Jan 2014
    Posts
    1

    Unhappy Getting unex err PLS-00306: wrong number or types of arguments in call to <Procedure>

    Hello,

    I am getting this particular error message on front end when my procedure is been called from TIBCO software. While when I execute the same procedure in TOAD then it is working fine and gives expecting result.
    Following is the structure of my procedure.

    CREATE OR REPLACE PROCEDURE ADMIN.COLLECT (
    IN_EMP_NO IN NUMBER,
    IN_TOTAL_REC IN NUMBER,
    OUT_STATUS OUT VARCHAR2,
    OUT_STATUS_MSG OUT VARCHAR2,
    OUT_DTLS OUT SYS_REFCURSOR
    )

    Please help me get out of this issue.

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,027
    So you are doing one or more of the following: passing in a variable that is not a number for the first two parameters, Not passing in VARCHAR variables that can be written to for the next two parameters, or not passing in a variable that is able to take a refcursor for the last parameter. You should show the actual code that you are running and the full error stack for that code, as well as the source code for the collect procedure if you have it.
    this space intentionally left blank

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width