Re: UNIX-Oracle script interface help

Hi SybaseUser_at_hotmail.com

I can't see anything strange in your script except for the exclamation mark as a delimitor. Try e.g. a text string like SQLEND, that's the only difference I can see compared to the script we use.

P.S.
Use the option /nolog and do the connect inside the script to hide user/password for the ps command...

Regards Jos

Senior DBA.

sybaseuser_at_hotmail.com heeft geschreven in bericht <74k85v$k53$1_at_nnrp1.dejanews.com>...
>Hi,
>
>Please excuse my email handle and help me with this Unix/Oracle shell
 script
>(Korn) problem:
>
>In my shell script I have:
>
>
>#!/bin/ksh
>
>LOGNAME=testid
>PASSWORD=testpw
>SPOOL_FILE=./test.log
>
>sqlplus -s $LOGNAME/$PASSWORD <<!
>spool $SPOOL_FILE
>set heading off
>set linesize 300
>
>select 'E1', a.sls_org_cd, a.dist_chnl_cd,
> a.doc_crncy_cd, a.cust_grp_cd, a.matl_cd,
> b.matl_nm
>from table_a a, table_b b
>where a.matl_id = b.matl_id;
>
>spool off
>!
>
>echo "TEST"
>
>
>Somehow the last line: echo "TEST" is being treated as a Oracle command and
>fed into Oracle and I got the following message in my output:
>
>unknown command beginning "echo "TEST"" - rest of line ignored.
>For a list of known commands enter HELP and to leave enter EXIT.
>
>I though the ! sign was sufficient to tell Oracle to exit the SQLPlus
 session
>(this is how it is done in Sybase). If I put "exit" before the ! sign then
>the entire UNIX script exits right there and the echo "TEST" statement
>doesn't get executed at all.
>
>Any help will be appreciated.
>
>Thanks
>
>Calvin L.
>sybaseuser_at_hotmail.com
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Wed Dec 09 1998 - 00:00:00 CST