Re: Who called me?

From: Ole C Meldahl <meldahl_at_pvv.org>
Date: Mon, 21 Jun 1999 12:30:52 +0200
Message-ID: <376E145B.A82D73D@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.

ole c

Jonathan Lewis wrote:

> 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
>
Received on Mon Jun 21 1999 - 05:30:52 CDT