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.