SQL & PL/SQL

Hi there,

I would like to utilize the DBMS_UTILITY package to capture errors in a log table. As stated in the following piece of code below in Oracle 10g database DBMS_UTILITY.FORMAT_ERROR_BACKTRACE function returns information about where the error originated from. Is there way this could be achieved on a Oracle 9i Database???

SQL> BEGIN
  2     will_error();
  3  EXCEPTION
  4     WHEN OTHERS THEN
  5        DBMS_OUTPUT.PUT_LINE( SQLERRM );
  6        DBMS_OUTPUT.PUT_LINE( DBMS_UTILITY.FORMAT_ERROR_BACKTRACE );
  7  END;
  8  /
ORA-06501: PL/SQL: program error
ORA-06512: at "SCOTT.WILL_ERROR", line 3
ORA-06512: at line 2

Thanks.

Edited by: Rowann on Jun 29, 2009 4:19 AM