Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Determine if a parameter has been passed
Hi,
There is a Stored procedure which has 10 parameters. All of the parameters are of type VARCHAR2. The invoker has been given the facility that, he/she may pass in only 3 out of the 10 parameters.
My question is this, is it possible to determine inside the Stored procedure, whether a parameter has been passed or not by the invoker?
Please note the invoker may pass NULL in any one of the parameters.
Regards
Amardeep Verma
Received on Thu Sep 20 2007 - 06:05:14 CDT
![]() |
![]() |