Test value of &1 before prompt

[fidge]

Hello all,

I have a script which takes a telephone nummber as its only variable i.e script 01256123456.

I would like to test that the variable given is
a) populated
b) all numeric, and
c) no greater than 11 chars in length.

I can test b and c, but not a, as if the script is run without a input variable it always prompts "Enter value for 1:"

How can I stop this from happening so I can test the input variable. Is there a way?

Thanks for your help.

 

[LKBrwnDBA]

No way José.

----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[fidge]

In that case, is there another way to pass in a variable?

 

[SantaMufasa]

Fidge,

Can you please post the code that you are using already, and then editorialise on the code how you would like it to behave if you had your wish?

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[LKBrwnDBA]

If you wish to pass an 'empty' value use double quotes:

SQL>@myscript.sql '' 'Value2' 3333

above would assign '' (emty string) to &1





----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb