Help! PL/SQL newbie here
Hello all,
We are trying to find a way to create stored procedure which can take 0 to 4 parameters (when 0 all would be blank).
Another idea is passing a cursor into other procedures (in the same package) if a parameter is provided, filtering cursor results, then returning final cursor.
We are trying to find a way to create stored procedure which can take 0 to 4 parameters (when 0 all would be blank).
One thought is to
use logic to define portions of the query constraints at
runtime.
Another idea is passing a cursor into other procedures (in the same package) if a parameter is provided, filtering cursor results, then returning final cursor.
What would be a good approach to this?
Thanks in advance!
Thanks in advance!
0