Home » SQL & PL/SQL » SQL & PL/SQL » Catching ORA-00054 properly
Catching ORA-00054 properly [message #254414] Thu, 26 July 2007 13:12 Go to next message
alp0001
Messages: 29
Registered: September 2005
Location: Illinois, USA
Junior Member
The error I'm trying to trap is the following:
http://download.oracle.com/docs/cd/B14117_01/server.101/b10744/e0.htm#ORA-00054

I've seen online examples use the following:
PRAGMA EXCEPTION_INIT(V_MY_EXCEPTION, -00054);
(OR)
PRAGMA EXCEPTION_INIT(V_MY_EXCEPTION, -54);

Will either method work?

The documentation doesn't really state much regarding this:
http://download.oracle.com/docs/cd/B14117_01/appdev.101/b10807/13_elems015.htm#LNPLS01315
Re: Catching ORA-00054 properly [message #254415 is a reply to message #254414] Thu, 26 July 2007 13:18 Go to previous messageGo to next message
BlackSwan
Messages: 25037
Registered: January 2009
Location: SoCal
Senior Member
>Will either method work?

What have you seen by actually TESTING both cases?
Re: Catching ORA-00054 properly [message #254418 is a reply to message #254414] Thu, 26 July 2007 13:28 Go to previous message
alp0001
Messages: 29
Registered: September 2005
Location: Illinois, USA
Junior Member
They appear to both work. Guess I was thinking that they were strings and as such:

"-00054" != "-54"
Previous Topic: help with analytical function to add extra lines
Next Topic: what is the use of dual table in oracle
Goto Forum:
  


Current Time: Mon Dec 05 07:01:41 CST 2016

Total time taken to generate the page: 0.04737 seconds