Re: Executing Procedures

From: Gerard H. Pille <ghp_at_skynet.be>
Date: Wed, 15 Feb 2012 19:21:09 +0100
Message-ID: <4f3bf77d$0$5057$ba620e4c_at_news.skynet.be>

Mladen Gogala wrote:
>
> There is also a way for procedure to answer the questions like: who am I?
> What is my purpose? What is the answer to the question of life, universe
> and everything? What is an airspeed velocity of an unladen swallow?
> Every PL/SQL object has the global VARCHAR2 variable $$PLSQL_UNIT which
> will return its name:
>
> 1 create or replace function tkyte_demo return varchar2 deterministic
> 2 as
> 3 begin
> 4 return($$PLSQL_UNIT);
> 5* end;
> SQL> /
>
> Function created.
>
> SQL> select tkyte_demo from dual;
>
> TKYTE_DEMO
> --------------------------------------------------------------------------------
> TKYTE_DEMO
>
> There is also a variable called $$PLSQL_LINE.
>
>
>

How refreshing, something I didn't know. Thanks! Is this documented somewhere? Received on Wed Feb 15 2012 - 12:21:09 CST