Re: Tool for applying SQL scripts required
From: Eric Givler <egivler_at_nttc.edu>
Date: 2000/05/03
Message-ID: <MC_P4.4683$wb7.468210_at_news.flash.net>#1/1
Date: 2000/05/03
Message-ID: <MC_P4.4683$wb7.468210_at_news.flash.net>#1/1
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 CEST