This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes how to catch ORA-00920 in PL/SQL procedure ? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "how to catch ORA-00920 in PL/SQL procedure ?" Watch "how to catch ORA-00920 in PL/SQL procedure ?" New topic
Author

how to catch ORA-00920 in PL/SQL procedure ?

Grace Green
Ranch Hand

Joined: Nov 08, 2010
Posts: 79
Is there a specific exception name to catch ora-00920 in PL/SQL ?
I know how to catch TOO_MANY_ROWS or OTHERS ?
ANything like INVALID_RELATIONAL_OPERATOR ?

Grace Green
Ranch Hand

Joined: Nov 08, 2010
Posts: 79
I found this list, but it does not contain ORA-00920

http://www.adp-gmbh.ch/ora/plsql/exception.html
Martin Vajsar
Sheriff

Joined: Aug 22, 2010
Posts: 3718
    
  61

You can declare your own exception and associate it with the ORA number. See http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14261/exceptioninit_pragma.htm

Just note that you must specify a negative number, in this case
 
Have you checked out Aspose?
 
subject: how to catch ORA-00920 in PL/SQL procedure ?
 
jQuery in Action, 3rd edition