Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
Grace Green
Ranch Hand
Posts: 79
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 79
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I found this list, but it does not contain ORA-00920

http://www.adp-gmbh.ch/ora/plsql/exception.html
 
Martin Vajsar
Sheriff
Pie
Posts: 3747
62
Chrome Netbeans IDE Oracle
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic