Re: SQLPLUS within UNIX script problem

The only reason, I am using this syntax is because I do not want the password to show up when someone does a ps -ef. By passing the password in as a variable, it does not show up on the ps command as opposed to sqlplus -s userid/password.

BTW, tried with hard coded variables, still the same result.

Harry

cgk1_at_rocketmail.com (ck) wrote in message news:<be868a14.0303051817.173c2ba9_at_posting.google.com>...
> harry827_at_yahoo.com (hs) wrote in message news:<12c8e030.0303040552.45507e87_at_posting.google.com>...
> > I have a command that looks like the following in a unix shell script
> > log=`sqlplus -s $DW_USER_at_$ORACLE_SID @$SCRDIR/$4 << +
> > $PSWD
> > +`
> >
> > When I look a the output in $log I not only see the result set but
> > also every file in that directory. Almost seems like echo * is
> > happening somewhere along the line. Anyone know how I can get around
> > this ?
>
> I would check to see what the value of each varible is. Is $4 null?
> The other thing I would do is run the script with hard coded values to
> see if it works that way and then trouble shoot from there. I've not
> used + for a marker so you might try to change that and see what
> happens.
>
> Does log have to be assigned the value of sqlplus? Can sqlplus run on
> it's own line and then redirect standard out to log or spool to log?
> Is it possible to set up an ops$ account to run the script? Then you
> would not need to pass in the password.
>
> I hope this gives you something to look at.
>
> >
> > Thanks
> > Harry
Received on Thu Mar 06 2003 - 20:35:47 CET