Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: What options for catching DDL exceptions in scripts sent to multiple users?

Re: What options for catching DDL exceptions in scripts sent to multiple users?

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Tue, 05 Jun 2007 21:34:38 +0200
Message-ID: <f44dsb$mr8$4@news5.zwoll1.ov.home.nl>


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Ed Prochak wrote:

>
> Sounds like a windows/DOS question. In the UNIX/Linux world, I'd
> redirect both standard out and standard error to a file and review the
> file afterward. I don't know how to do the equivalent on DOS. (It's
> been just too long andf the memories of DOS are just too painful.)
>
> Ed
>

It's more or less the same, Ed.
Just redirect (sqlplus @update_script > errors.log)

Or, start each script with a simple "spool" command

Top-posting is one way to shut me up...
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (MingW32)

iD8DBQFGZbrOLw8L4IAs830RAnkmAJ9AC1ky1ksStp7BR+hn++Ab1VCwVgCePsR7 LpmsEI4Xwalb9vZ0WgqLOP0=
=O9Bc
-----END PGP SIGNATURE----- Received on Tue Jun 05 2007 - 14:34:38 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US