Re: sqlplus and stdout... SEEING WHAT RAN??

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Fri, 13 May 2005 16:45:45 +0200
Message-ID: <4284bebd$0$316$626a14ce@news.free.fr>

<jason_at_cyberpine.com> a écrit dans le message de news:1115994066.089071.132150_at_g49g2000cwa.googlegroups.com...
| Good day.
|
| What's the best way to see what sqlplus commands were executed in a
| script output? I've tried ECHO ON and SET SERVEROUTPUT ON in my POSIX
| script, but neither show me the commands executed as they are
| excecuted...
|

"set echo on" displays the command that are executed within a SQL script and not directly.
So put all your commands in SQL script and execute it via "start myscript.sql" in your shell script. Then you'll get all the sql commands.

Regards
Michel Cadot Received on Fri May 13 2005 - 09:45:45 CDT