Capture exact error in exception section

[gopi]

(9i)
Can I capture an exact Oracle error message in an exception section of a trgger (one that I want to ignore)?

Any syntax help would be greatly appreciated.

[gopi]

I swear I spend 45 minutes in the Oracle documentation yesterday and did not find what I was looking for.

Today is a different story:

DECLARE
deadlock_detected EXCEPTION;
PRAGMA EXCEPTION_INIT(deadlock_detected, -60);
BEGIN
...
EXCEPTION
WHEN deadlock_detected THEN
-- handle the error
END;

[Mlimaye]

Try PL/SQL variable SQLERRM. It contains Oracle error msg text. Here is an example. I haven't tried it in a trigger.

SQL> ed
Wrote file afiedt.buf

1 DECLARE
2 I NUMBER;
3 BEGIN
4 SELECT O_ID INTO I FROM Orders;
5 EXCEPTION
6 WHEN OTHERS THEN
7 DBMS_OUTPUT.PUT_LINE(SQLERRM);
8* END;
SQL> /
ORA-01422: exact fetch returns more than requested number of rows

PL/SQL procedure successfully completed.

SQL>


Rgds,
M