Re: How to check owner of package

From: Arman Rawls <nospam_adrawls_at_stupp.com>
Date: 1997/08/20
Message-ID: <01bcad72$222ca740$65010c0a@is_arawls>#1/1

If you are putting the SQL statement in the package then how about using this to retrieve the information into your variable: select owner
from all_objects
where object_name=<package name>
and object_type='PACKAGE'

Cezariusz Marek <Cezariusz.Marek_at_comarch.pl> wrote in article
> How to check in package (at the runtime) who is the owner of it. The
> line:
>
> select user
> into v_usr
> from dual;
>
> gives me the user who executed package, not in who's schema it was
> created.
Received on Wed Aug 20 1997 - 00:00:00 CDT