Re: Passing parameters to sql*plus ??

I've been trying to do this as well and have only been able to do it with one parameter. I use:

        echo "parm_value" | sqlplus user/password

moan_at_sn.no (Alexander Moan) wrote:

>Howdy (or something) !
 

>How do I pass parameters to sqlplus on startup of a script ?
>I have been able to do a workaround to this by using an
>append of define *something* into login.sql from a unix shell-scipt,
>but i don't like this approach.

You cannot access UNIX variables inside sqlplus as far as I know thats why I use the above to pass it in. I wish I knew a way to do more than one.

        echo $ENV_VALUE | sqlplus user/password
>Is it possible to access Unix env. variables from inside sql*plus ?
 

>Any help appreciated !
 

>--
>----------------------------------------------------------
>| Alexander Moan --:-) moan_at_sn.no |
>| Any statements I make are my own, and are not to be |
>| taken as an statement from my employer. |
>| |
>| Norwgian Defence Command Norway |
>| Home Guard Staff |
>| |
>| "Don't blame me, I just work here !" |
>---------------------------------------------------------
Received on Wed Aug 14 1996 - 00:00:00 CEST