|   
   | This helps.  I guess I was hoping not to pass all 20+ parameters that this   
   procedure accepts.   
   |   
   | As a function, I am able to call the function passing only the parameters I   
   need, using the named parameter method.   
   |   
   | But in this syntax, if I omit the first parameter, I get an error.   
   |   
   | There must be a way, say from SQLPlus, to call a procedure, and only supply   
   the parameters you need for that call.....not all of   
   the parameters in a positional line.......   
   |   
   | Thanks.   
      
      
   >>> But in this syntax, if I omit the first parameter, I get an error.   
      
   Why don't you copy and paste what you do and get as I did instead of trying to   
   explain it (and failing as I don't understand what   
   you actually did)?   
      
   Regards   
   Michel   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)