SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Find out schema

1011349May 28 2013 — edited May 28 2013

Hi,

I need to find out in DB Package where this Package is installed (in which schema). The problem is this DB Package can be installed in various schemas. This means that I can't use select user from dual or system environment SYS_CONTEXT('USERENV', 'OS_USER').

What I would need is something like $$PLSQL_UNIT

cheers,
Johannes

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 25 2013

Added on May 28 2013

8 comments

221 views