DCG_Developer
asked on
PLS-00049: bad bind variable when calling stored procedure
I am trying to call a stored procedure from within an existing Oracle stored procedure. The stored procedure I am attempting to call returns a ref cursor. The issue I encountered is I can't seem to define the ref cursor variable I need to pass to the stored procedure correctly. I keep getting the error: "PLS-0049: bad bind variable". See below code example.
Any help you could provide would be greatly appreciated.
Any help you could provide would be greatly appreciated.
Procedure Some_Procedure IS
x ref_cursor;
Begin
Other_Proc('1','2','3','4',:x);
End Some_Procedure;
-- Other Procs in/out variables
Procedure Other_Proc
(
var1 varchar2,
var2 varchar2,
var3 varchar2,
var4 varchar2,
P_CURSOR IN OUT RET_REFCURSOR);
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
no problem, glad I could help
ASKER