Skip to Main Content

Oracle Database Discussions

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!

Object types in packages

user545194Apr 25 2024 — edited Apr 25 2024

Env. 19c SE2

Are procedures, functions, and types that reside in packages registered in a dictionary or only as standalone objects? I would assume not since a “create or replace procedure” inside of a package is not possible.

Querying ALL_PROCEDURES and ALL_ARGUMENTS apparently show either package or procedure or function. We are aiming to get a list of object types that are inside packages.

Thanks!

Comments
Post Details
Added on Apr 25 2024
4 comments
677 views