Re: Environment within PL/SQL (like environment variables)

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Thu, 29 Jun 2006 11:14:19 -0400
Message-ID: <oo-dnapo0MrWcz7ZnZ2dnUVZ_oudnZ2d@comcast.com>

"Jeremy" <jeremy0505_at_gmail.com> wrote in message news:MPG.1f0dfc6c1f3f1ffe98a22f_at_news.individual.net...
: In article <u9ydnccm_PHOdj7ZnZ2dnUVZ_sOdnZ2d_at_comcast.com>, Mark C. Stock
: says...
: >
: > "Jeremy" <jeremy0505_at_gmail.com> wrote in message
: > news:MPG.1f0df86dd84782af98a22d_at_news.individual.net...
: > : In article <1151512673.587840.130720_at_b68g2000cwa.googlegroups.com>,
: > : Vladimir M. Zakharychev says...
: > :
: > : >
: > : > http://asktom.oracle.com/~tkyte/who_called_me/index.html
: > :
: > : Although now I look at it it doesn't return the name of the procedure
: > : within a package. Useful but not a complete solution - thanks again.
: > :

:

: >
: > you'll need to extrapolate that from the line number -- not easy, but
doable
: >

:
:

: Come on mark, give us a clue ;)

:

: Does this include reading through user_source?

:
:

: --

:
: jeremy

your getting warmer...

actualy, yes. although you could set up some derived data (perhaps maintained via a schema trigger) that would make the runtime operation a bit easier and more performant.

++ mcs Received on Thu Jun 29 2006 - 10:14:19 CDT