Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Determine if a parameter has been passed

Determine if a parameter has been passed

From: <addverma_at_gmail.com>
Date: Thu, 20 Sep 2007 04:05:14 -0700
Message-ID: <1190286314.575590.308470@i13g2000prf.googlegroups.com> 





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












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US