get second Error Message in Exception Handling

From: Gernot Schneider <gernot_at_4schneider.com>
Date: 21 Aug 2003 04:29:50 -0700
Message-ID: <12a12617.0308210329.3b953ced@posting.google.com>

Hi all,
I have a problem.
I'm getting an oracle error with two messages: ORA-02291: integrity constraint (VARMAN.UICOMMANDPROP_FK_UIABSTRACTTO) violated - parent key not found
ORA-06512: at line 59

When I catch the error from SQLERRM I get only the first error (ORA-02291...).
But I need also the second error which specifies the line number.

Has anybody an idea how to do this?

Here is my exception handling code:
EXCEPTION
  WHEN OTHERS THEN
    DBMS_OUTPUT.PUT_LINE('Error in varman_search.sql');     err_msg := SUBSTR(SQLERRM, 1, 200);
    DBMS_OUTPUT.PUT_LINE(err_msg); Received on Thu Aug 21 2003 - 06:29:50 CDT