Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Who called me?
Hi
I agree, still messy but better! Not getting the parameterlist can be acceptable(due to overloading), but distinguishing comments from the rest is slightly more difficult.
What about the object handle, from the stack:
object line object
handle number name
c7f526a0 6 procedure SPORT.WHO_CALLED_ME c81080b8 1 anonymous block c81080b8 1 anonymous block
Can I do a search somewhere to match this to something real?
ole c
Jonathan Lewis wrote:
> Good point - I'd forgotten that.
>
> How about getting the list of function and procedure
> names for the PACKAGE from all_source, and then
> checking whether then function/procedure found
> was in that list ?
>
> Still a bit messy, because of overloading, etc.
>
> --
>
> Jonathan Lewis
> Yet another Oracle-related web site: www.jlcomp.demon.co.uk
>
> Ole C Meldahl wrote in message <376E145B.A82D73D_at_pvv.org>...
> >Thanks for the input! For my purposes the body will always be visible(I
> want
> >to add debug-information). Searching upwards for FUNCTION/PROCEDURE will be
> >correct in most cases, but functions within functions exists, same with
> >PROCEDURE in strings. I would prefer to avoid complete parsing.
Received on Tue Jun 22 1999 - 04:45:35 CDT