Getting unex err PLS-00306: wrong number or types of arguments in call to <Procedure>
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.
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
Click Here to Expand Forum to Full Width