SQL*Plus and Shell Programming

I run most of my SQL scripts via kornshell on AIX.

I use the "here-document" to run some of the smaller ones.

Example:
#!/bin/ksh

# Analyze the table.
sqlplus ${SCHEMA_NM}/${SCHEMA_PASSWD}_at_${DB_NM} <<-ANALYZE_TABLE SET TERMOUT ON
SET FEEDBACK ON
SET SQLBLANKLINES ON
SET TIMING ON
SET SERVEROUTPUT ON SIZE 1000000
SET ECHO ON
BEGIN
HP.ANALYZE_TABLE ( TABLE_NM => 'ADGPMP' ); END;
/
ANALYZE_TABLE As I look at it from my telnet window I don't see the feedback...

Here is what I see:

SQL> SET TERMOUT ON
SQL> SET FEEDBACK ON
SQL> SET SQLBLANKLINES ON
SQL> SET TIMING ON
SQL> SET SERVEROUTPUT ON SIZE 1000000
SQL> SQL> SQL> SQL> SQL> SQL> SQL>   2    3    4  

Elapsed: 00:00:01.01

This sure makes log file reading a pain! Does anyone know how I can see the SQL or (PL/SQL in this case) that is being executed?

Thanks! Received on Wed Jan 28 2004 - 23:30:47 CET