From:Steve Adams
Date:01-Nov-2001 17:15
Subject:   How to get the constraint name when an exception is raised

Yes, have a look at DBMS_UTILITY.FORMAT_CALL_STACK. You can get some examples of how to use it on the AskTom website.

Is there a way to get the constraint name when an exception is encountered in a PL/SQL procedure?