21.6 External Procedure Housekeeping

Chapter 21
External Procedures

 

---

Here are some not-so-obvious bits of information that will assist you in creating, debugging, and managing external procedures.

21.6.1 Data Dictionary

There are only a handful of entries in the data dictionary that help manage external procedures. As we have mentioned elsewhere, although Table 21.2 gives the USER_ version of the dictionary table, note that there are corresponding entries for DBA_ and ALL_.

Table 21.2: Data Dictionary Views for External Procedures

To Answer the Question...	Use This View	As In
What libraries have I created?	USER_LIBRARIES	SELECT * FROM user_libraries;
What packages depend on library foo?	USER_DEPENDENCIES	SELECT * FROM user_dependencies WHERE referenced_name = 'FOO';
What is the source code for the spec of my PL/SQL package "bar" that calls the library?	USER_SOURCE	SELECT text FROM user_source WHERE name = 'BAR' AND type = 'PACKAGE' ORDER BY line;
What is the source code for my PL/SQL package body named bar that calls the library?	USER_SOURCE	SELECT text FROM user_source WHERE name = 'BAR' AND type = 'PACKAGE BODY' ORDER BY line;