Re: Parsing the spool file.....

Brian Peasland schreef:

> In your script, add "set echo on" as one of the first things done in
> SQL*Plus. This way, you will see the SQL statement being echoed in the
> SQL*Plus session.

But it will double the size of the output...
>
> If you want to parse the ORA- errors and display ten lines before that,
> then you'll probably have to write your own parser. It shouldnt' be too
> hard in Perl. Otherwise, I typically load the log file into vi and do
> ":/ORA-" to search for the first occurrence of ORA- in the file. That
> will show me the error line and the first few lines above it. To see the
> next occurence, type "/" followed by return. Repeat as necessary. You
> can do a similar op in other editors too.

Just make it a habit to code "show error" after every statement.
set termout off echo off may improve speed; it will not affect spooled output.

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...