Can we create store procedure with optional Parameters?
Hello All,
Just wanted to ask you regarding Store Procedure.
we have One store procedure with 300 Parameters (some in ,some in/out, and some out) , so each and every time when we call procedure,
we have to pass NULL value for in parameters and for in/out or Out parameters i have to pass variables with no value.
Instead of this can we build a procedure that has Optional Parameters.
i.e. when we call procedure at that time we pass only the needed parameters others can be avoided at that time.
Should it be possible in Oracle PL/SQL ? if it is possible then how can we achieve this(general syntax of that procedure)?
we have One store procedure with 300 Parameters (some in ,some in/out, and some out) , so each and every time when we call procedure,
we have to pass NULL value for in parameters and for in/out or Out parameters i have to pass variables with no value.
Instead of this can we build a procedure that has Optional Parameters.
i.e. when we call procedure at that time we pass only the needed parameters others can be avoided at that time.
Should it be possible in Oracle PL/SQL ? if it is possible then how can we achieve this(general syntax of that procedure)?
0