Re: How do you pass a value from a shell script into a sqlplus script?

From: isa <isapmon_at_terra.es>
Date: Mon, 21 Oct 2002 17:45:53 GMT
Message-ID: <l3Xs9.1012277$sI1.8093170@telenews.teleline.es>

Hi:

In the shell script: @fichero.sql PARAM1 PARAM2 PARAM3

In the sql: where field1 = '&1' and field2 = '&2' and field3 = &3

where parameters 1 and 2 are character and the 3 is numeric.

Regards,

Isa

"Mike J" <mjjwestford_at_hotmail.com> escribió en el mensaje news:ur885v82jtbt45_at_corp.supernews.com...
> I gather parameter values in a korn shell script and want to use them in a
> sqlplus script that is called from the shell script. How do you pass a
value
> into the sqlplus script?
>
>
Received on Mon Oct 21 2002 - 12:45:53 CDT