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

[Grace Green]

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 ?

BEGIN
		SELECT *
		FROM tableName
		WHERE ....;
   EXCEPTION
        WHEN 
             TOO_MANY_ROWS THEN RAISE_APPLICATION_ERROR(-20001,'Exact Fetch Returned Too many Rows');
  	WHEN 
            OTHERS THEN
			do something;
	END;

[Grace Green]

I found this list, but it does not contain ORA-00920

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

[Martin Vajsar]

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 casePRAGMA EXCEPTION_INIT(INVALID_RELATIONAL_OPERATOR, -920);