Re: Tool for applying SQL scripts required

It's called SQL*Plus.

Put a:
whenever sqlerror exit failure in your top most script followed by:
set document on
set echo on
spool filename.log

then a spool off at the end

Would that be enough?

"Mike Taylor" <mike_at_usfour.freeserve.co.uk> wrote in message news:8enfuc$68f$1_at_newsg4.svr.pol.co.uk...
> Iam looking for a tool to execute SQL scripts that are stored in a text
 file
> but with the ability to stop if a statement fails, so I can adjust the
 code,
> grant a privilege, (that sort of thing) and then restart from the
 statement
> that failed with all activity logged.
>
> Any ideas?
>
>
Received on Wed May 03 2000 - 00:00:00 CDT