How to get current program line number in exception?

How to get current program line number in exception?

Hello. I'd like to get current program line number, where raised exception.

My code is:
create or replace procedure qqq
as
n varchar2(1) := '12';
begin
null;
exception when others
dbms_out.put_line(sqlerrm);
end;
/

execute qqq;

output will be:
ORA-06502: PL/SQL: numeric or value error: character string buffer too small

but I would like to get:

ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "SCOTT.QQQ", line 2
ORA-06512: at line 2

How can I do this? Received on Wed Apr 24 2002 - 08:05:35 CDT