Re: Is it possible to pass args. to a sql script

Casper Thrane wrote:
>
> Hi
>
> I have a sql-script in a file which i execute from sql-plus, but is it
> possible to pass arguments when I execute this script?
> --
> Casper Thrane
> Systemdeveloper
> Benau A/S
 

Sure.

In your script, identify the variables by position: $1, $2, $3, ...

Then call your script within SQL*Plus:
@script value1 value2 value3 ... Received on Thu Nov 20 1997 - 00:00:00 CST