Hi,

I wrote this piece of code to get current procedure name but having error 6502 when executing it.

Can any one know why is it so?

Thks





SQL*Plus: Release 10.2.0.1.0 - Production on Tue Nov 14 17:20:03 2006

Copyright (c) 1982, 2005, Oracle. All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options


SQL> l
1 create or replace procedure my_proc
2 is
3 l_proc varchar2(1024);
4 begin
5 l_proc := owa_util.GET_PROCEDURE ;
6 --raise_application_error(-20001,l_proc);
7* end;
SQL> /

Procedure created.

SQL> exec my_proc
BEGIN my_proc; END;

*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "SYS.OWA_UTIL", line 325
ORA-06512: at "SYS.OWA_UTIL", line 2389
ORA-06512: at "D269732.MY_PROC", line 5
ORA-06512: at line 1


SQL>