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.
Procedure Some_Procedure IS
-- Other Procs in/out variables
P_CURSOR IN OUT RET_REFCURSOR);