| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: PL/SQL procedure or package owner ?
[[ This message was both posted and mailed: see
the 'To' and 'Newsgroups' headers for details. ]]
On Thu, 13 Jan 2000 12:55:27 +0100, Igor V. Podolsky wrote (in message <AAZqRVuy900_at_soft-review.kiev.ua>):
> Hi !
>
> Is there a way to determine a package (or procedure) owner from the package
> ?
> I need to write procedure that works by following way: it should always
> return it owner (it scheme name by other words).
> There is a built-in 'user' procedure but it returns name of user that called
> it, not owner name.
> Any suggestions ?
How about the callstack ? It has the names of the routine that called and also the schema that routine belongs to.
--
Ronald.
 |
 |