how to get message of line/col in EXCEPTION?

From: <cheasy_at_gmail.com>
Date: 13 Oct 2006 00:05:20 -0700
Message-ID: <1160723120.099436.46030@f16g2000cwb.googlegroups.com>

CREATE OR REPLACE PROCEDURE pro_testErr IS   n_num NUMBER;
BEGIN
  SELECT 1/0 INTO n_num FROM dual WHERE 1=1; END pro_testErr;

---

SQL> exec pro_testerr;
BEGIN pro_testerr; END;

*
ERROR at line 1:

ORA-01476: divisor is equal to zero
ORA-06512: at "CE.PRO_TESTERR", line 4
ORA-06512: at line 1


------------------------------------------------------------------------


================================================================

CREATE OR REPLACE PROCEDURE pro_testErr IS   n_num NUMBER;
BEGIN
  SELECT 1/0 INTO n_num FROM dual WHERE 1=1;

EXCEPTION
  WHEN OTHERS THEN
    dbms_output.put_line(SQLERRM);
END pro_testErr;

SQL> set serveroutput on
SQL> exec pro_testerr;
ORA-01476: divisor is equal to zero

PL/SQL procedure successfully completed.

SQL> why SQLERRM not include message of line/col? how to get that message in procedure? thx. Received on Fri Oct 13 2006 - 02:05:20 CDT