Re: Who called me?

You could write a procedure to take a package name and line number, then select from all_source where type = 'PACKAGE BODY' for the first occurrence of the word PROCEDURE or FUNCTION prior to that line number.

The general difficulty, though, is that whilst you may be allowed to execute that package you might not be allowed to see the package body.

--

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

Ole C Meldahl wrote in message <376DEA14.7F7961E4_at_pvv.org>...
>Hi
>
>http://govt.us.oracle.com/~tkyte/ contains a script formatting the
>callstack to show the pl/sql that called the current code. Unfortunatly
>the callstack only shows the name of the package, and the line no
>within the body.
>
>Is it possible to get the information on the format
>'schema.package.procedure' in some other way, or is it necessarry to
>extract the information based on line no? If so, does anybody have a
>procedure giving the procedure name based on line no?
>
>ole c
>
>
Received on Mon Jun 21 1999 - 02:55:07 CDT