Re: UNIX-Oracle script interface help

To my knowledge the ! symbol in sql*plus means calling an operating system command with in sql*plus . When u run a ! from sql*plus it will give u a $ prompt meaning, u have to enter an operating system command .

There are 2 ways to resolve your problem :-

1. Replace your ! with exit if u are using ! to exit from sqlplus and then give an echo "TEST" command . For eg :-

        .......
        ........
       spool off
       exit
       echo "TEST"

    This way the echo "TEST" will be executed once
     the ksh script exits out of the sql*plus .

 2.  If u want to run echo "TEST" with in sql*plus
      , do the following :-

       ......
       .....
       spool off
       ! echo "TEST"
           (or)
       host echo "TEST"

Thanks
Sai Received on Fri Dec 11 1998 - 00:00:00 CST