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.