Counting arguments passed to SQL or PL/SQL?

From: Jeff Wilson <jwilson2000_at_home.com>
Date: Tue, 26 Jun 2001 01:09:39 GMT
Message-ID: <nhRZ6.246704$p33.4982544_at_news1.sttls1.wa.home.com>


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-8590
Received on Tue Jun 26 2001 - 03:09:39 CEST

Original text of this message