Are all of the Oracle exceptions named?
Posted
by
John O
on Stack Overflow
See other posts from Stack Overflow
or by John O
Published on 2013-10-23T15:49:56Z
Indexed on
2013/10/23
15:53 UTC
Read the original article
Hit count: 164
In particular, I've been trying to find the name of the ORA-0955 to improve code readability.
Currently I'm using the following:
EXCEPTION
WHEN OTHERS THEN
IF SQLCODE = -00955
What I would prefer is something like:
EXCEPTION
WHEN OBJECT_EXISTS THEN
This seems cleaner to me and I would prefer that. But I've looked in SYS.STANDARD, and it lists relatively few named exceptions. Online documentation seems to mirror what's in SYS.STANDARD. Is there another package to look in? Some other resource?
© Stack Overflow or respective owner