Optional output cursor as parameter

Question

I'm trying to cater for two applications.

One calls a procedure with 2 cursors, the other with 1.

Both are OUT SYS_REFCURSOR.

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.

Thanks, JFIT

Answer 1

What about method overloading?

PROCEDURE Proc_GetQ (qList OUT SYS_REFCURSOR, qStack OUT SYS_REFCURSOR);
PROCEDURE Proc_GetQ (qList OUT SYS_REFCURSOR);

Create a procedure with the same name, similar logic (better call 2-parameter version inside and pass only one outside), but only one OUT parameter.