Toad World® Forums

SQL*PLUS Parameters

In SQL*PLUS parameters must be named &1, &2, &3, ...

However, when defining a variable in an automation, it cannot begin with a number.

Is there a way around this?

Would be an enhancement request to support directly. Can you describe your use case, and why you can't use other names for your variables?

1 Like

Thanks for your reply! Our historic processes run sqlplus in a .bat file. The parameters (to my knowledge) can only be numeric based on their location after the file (see attached). We would like to still be able to run via batch if needed (Toad Data Point issue, disaster recovery, etc.)