Re: help with exceptions please

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Tue, 25 Sep 2007 20:48:55 +0200
Message-ID: <fdbl6o$2k3$1@news1.zwoll1.ov.home.nl>

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

jgarfield_at_earthlink.net wrote:
> also, as for the terminology are the ones with negative numbers called
> exceptions too? Or application errors? Just trying to understand
> here.
>

All exceptions (and other errors) have negative numbers; all of them are reserved for use by Oracle, except the - -20000 ~ -20999 range - there are called 'user defined exceptions'

The -1234 you were using in an earlier example is a redefinition of an existing error - possible, allowed, but be careful: you might attach a completely different text (and thus understanding by the operator) to the original error.

If it's not something predefined, use the range above. And it's quite common to misuse the -20000 over and over, with different text.

ORA-01234: cannot end backup of file string - file is in use or recovery - --
Regards,
Frank van Bortel

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

iD8DBQFG+VgXLw8L4IAs830RAqn1AJkBAJb11z297tv3srYGKwOAcmiz4gCeIJrJ CKlfow4VmDt8UBuB2KE+Ie8=
=JXY3
-----END PGP SIGNATURE----- Received on Tue Sep 25 2007 - 13:48:55 CDT