Echo for SQL scripts

deltacorvi · #1 (**permalink**) 09-27-04, 14:58

Hi all,

I want to see input SQL statements in the log file when I run the script in SQLPlus. I have used this set command "SET ECHO ON" for this. However, the log file looks like this -

drop table table_A
*
ERROR at line 1:
ORA-00942: table or view does not exist

7444 rows deleted.

Commit complete.

Thus, the SQL statement is not visible if it is error free. Is there a way to get around this?

Thanks

LKBrwn_DBA · #2 (**permalink**) 09-28-04, 11:27

Did you try to SPOOL the results?
This will do it:

Code:

SET ECHO ON
SPOOL logfile.log
@MyScript
SPOOL OFF

deltacorvi · #3 (**permalink**) 09-28-04, 14:39

I added these commands in my script -

set echo on
spool log_file.log
@script_name.sql
spool off

the log file only had this error message -

SP2-0309: SQL*Plus command procedures may only be nested to a depth of 20.

LKBrwn_DBA · #4 (**permalink**) 09-28-04, 14:44

Quote:

Originally Posted by deltacorvi

I added these commands in my script -

set echo on
spool log_file.log
@script_name.sql
spool off

the log file only had this error message -

SP2-0309: SQL*Plus command procedures may only be nested to a depth of 20.

This error means what it means: your script executes a script that executes a script ...etc upto more that 20 levels deep.

Internet Services

Web Development

Digital Marketing

Consumer Tech