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

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 - 11:02:34 CDT