Hi, all
This is a one way (in example I create function, but it also can be a
procedure (package, trigger and ... ;)
SQL> col test format a40 trunc
SQL> create or replace function test return varchar2
2 is
3 begin
4 return rtrim(substr(dbms_utility.format_call_stack,
instr(dbms_utility.format_call_stack, '.')+1),chr(10));
5 end;
6 /
Function created.
SQL> select test from dual;
TEST
----------------------------------------
TEST
PS: From city Almaty, republic Kazakhstan
----- Original Message -----
From: "Ofer Harel "
<oracledba-ezmlmshield-x45025389.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Thursday, June 29, 2006 3:36 PM
Subject: Procedure name within the procedure
> Good morning;
>
> Is there a way to select the procedure name inside a procedure (without
> creating a variable by the programmer) ?
>
> regards
> Ofer Harel
> DBA 013Barak
>
>
>
> **********************************************************************
> The information contained in this e-mail message may be
> privileged and confidential. The information is intended only
> for the use of the individual or entity named above. If the
> reader of this message is not the intended recipient, you are
> hereby notified that any dissemination, distribution or copying
> of this communication is strictly prohibited. If you have
> received this communication in error, please notify us
> immediately by telephone, or by e-mail and delete the message
> from your computer. Thank you!
> Unless otherwise stated, any views or opinions expressed in
> this e-mail are solely those of the author and do not represent those of
> Barak I.T.C (1995) The International Telecommunications Services Corp.
Ltd.
> **********************************************************************
>
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these
terms:http://www.lazydba.com/legal.html
>
Oracle LazyDBA home page