Re: Dtermining the package name inside the package

From: Andy Hardy <aph_at_ahardy.demon.co.uk>
Date: Fri, 25 Jun 1999 09:56:02 +0100
Message-ID: <VF6HjJAiQ0c3EwHr@ahardy.demon.co.uk>

In article <7ku5e2$grd$1_at_nnrp1.deja.com>, Michael <moores_at_my-deja.com> writes
>Is there a way to determine the name of a PL/SQL package from within
>the package?

You can parse the results of DBMS_UTILITY.FORMAT_CALL_STACK (returns a string of all currently executing procedures).

But it's probably easier/quicker to just do it manually with a constant in the package itself!

Andy
>--Michael
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.

--
Andy Hardy. PGP key available on request

Received on Fri Jun 25 1999 - 03:56:02 CDT