Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

package specification and body

641016Aug 25 2008 — edited Aug 26 2008
Hi there...
I want to know how package specification and body are linked internally...though they are created and stored seperately in the
database...

Comments

Cuauhtemoc Amox
By name =)? You can have a package specification only with no implementation, and so as You guess there may be some internal mechanism but I haven't seen it documented on user guides. Perhaps DBA's may have knowledge on how those structures are stored internally, as the parsed and compiled code is stored and loaded for execution, not the text we see in user|all|dba_source.
damorgan

One way:

SELECT name, referenced_name, referenced_type
FROM dba_dependencies
WHERE name = 'UTL_FILE'
AND referenced_type like '%PACKAGE%'
UNION
SELECT name, referenced_name, referenced_type
FROM dba_dependencies
WHERE referenced_name = 'UTL_FILE'
AND referenced_type like '%PACKAGE%';
1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 23 2008
Added on Aug 25 2008
#code, #pl, #sql
2 comments
260 views