| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.tools -> Counting arguments passed to SQL or PL/SQL?
Have checked all the on-line FAQs but can't find the answer to this.
Have a PL/SQL script that takes optional arguments for switches and such. I know &1, &2, etc., represent these arguments, but is there a variable that represents the number of arguments?
The problem I'm having is that if a variable is not passed in, then SQL asks for it's value if it is encountered in the script. I need some way of knowing if a variable is set.
Thanks.
-- Jeff Wilson jwilson2000_at_home.com Eugene, Oregon (541) 684-8590Received on Mon Jun 25 2001 - 20:09:39 CDT
![]() |
![]() |