Re: A little help with a sqlscript needed ...

Thomas, you can invoke SQL*Plus with the "silent option" (-s) to suppress the unneeded messages. The command would look something like this:

   sqlplus -s <user>/<password> @my_script.sql

Note: I used the "@" to execute the script.

HTH
   James

In article <362CAFE8.8C479A24_at_mobilkom.at>, t.klinger_at_mobilkom.at wrote:

>Hi there!
>
>Maybe one of you can help me.
>I have 2 scripts, one shellscript and one sqlscript.
>The shellscript should pipe the sqlscript into sqlplus this way:
>...
>sqlplus <user>/<password> < my_script.sql
>...
>
>The output is like this:
>...
>Connected to:
>Oracle7 Server Release 7.3.2.3.0 - Production Release
>With the distributed option
>PL/SQL Release 2.3.2.3.0 - Production
>
>SQL> DOC>DOC>SQL> SQL> SQL> SQL> SQL> SQL> SQL> 2 3 4 5
>6 7 8 9
>...
>SQL> 2 3 4 5 6 7 8
>...
>SQL> 2 3 4 5 6 7
>...
>SQL> Disconnected from Oracle7 Server Release 7.3.2.3.0 - Production
>Release
>With the distributed option
>PL/SQL Release 2.3.2.3.0 - Production
>...
>
>How can I handle this that the output is only the information I want and
>not this boring lines between?
>I already tried to set everything off:
>set verify off
>set feedback off
>set echo off
>...
>
>Can somebody help me? Thanks in forward.
>
>Kind regards, Thomas
>
>P.S.: This happens on HPUX 10.20 with ORACLE 7.3.2, csh-environment
--

lorenzen_at_yuck.net             | Life is complex; it has
                              |   real and imaginary parts