Re: SQLPLUS within UNIX script problem

Hi,

Put the closing apostrophe in the next line. I am running something similar, but with different database and on SCO - it works:

> heads_out=`
> dbaccess harness 2>/dev/null <<!!
> output to pipe cat without headings
> select count(*) from tmp_head where filename = "$FILENAME";
> !!
> `

HTH Michael

hs wrote:

>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 ?
>
>Thanks
>Harry
>
>
Received on Thu Mar 06 2003 - 20:55:49 CET