I'm trying to cater for two applications.
One calls a procedure with 2 cursors, the other with 1.
Because of the difference in definition of the procedure, the change to one application will break the other.
I am wondering if its possible to have the same procedure with both
OUT SYS_REFCURSOR but with the second parameter as optional. This is done in other parts of the project by defining a default value.
I have tried googling and defining default values but to no avail. This doesnt seem to be a very common issue.
Is there a way to have this definition with an optional
OUT SYS_REFCURSOR ?
Here is my code:
PROCEDURE Proc_GetQ (qList OUT SYS_REFCURSOR, qStack OUT SYS_REFCURSOR);
I would like qStack to be optional.