Oracle PL/SQL Programming, 2nd Edition

Oracle PL/SQL Programming, 2nd EditionSearch this book
Previous: 21.5 OCI Service RoutinesChapter 21
External Procedures
Next: 21.7 Examples
 

21.6 External Procedure Housekeeping

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;

21.6.2 Rules and Warnings About External Procedures

As with almost all things PL/SQL, external procedures come with an obligatory list of cautions:


Previous: 21.5 OCI Service RoutinesOracle PL/SQL Programming, 2nd EditionNext: 21.7 Examples
21.5 OCI Service RoutinesBook Index21.7 Examples

The Oracle Library Navigation

Copyright (c) 2000 O'Reilly & Associates. All rights reserved.

Library Home Oracle PL/SQL Programming, 2nd. Ed. Guide to Oracle 8i Features Oracle Built-in Packages Advanced PL/SQL Programming with Packages Oracle Web Applications Oracle PL/SQL Language Pocket Reference Oracle PL/SQL Built-ins Pocket Reference
This HTML Help has been published using the chm2web software.