Re: Can a PL/SQL procedure or function tell its own name ?

On Nov 16, 11:28 am, "Syltrem" <syltremz..._at_videotron.ca> wrote:
> Hello
>
> I'm looking for a way to tell, in a PL/SQL named procedure or function, the
> name of the procedure or function.
>
> For example
>
> CREATE or REPLACE PROCEDURE XXX as
> BEGIN
> dbms_output.put_line('this is procedure XXX running');
> END;
> /
>
> Is there a special variable like those ora_something that exist, which would
> contain the name of the executing procedure ? Or some other way to do this ?
>
> Thanks !
>
> Syltrem
> Oracle 10gr2 on OpenVMS

Check out sys_context and dbms_application_info. http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_appinf.htm#sthref460 http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:767025833873

jg

--
@home.com is bogus.
http://www.signonsandiego.com/uniontrib/20071115/news_1b15divx.html