Advanced Oracle PL/SQL Programming with Packages

5.20. PLVobj: Object Interface

The PLVobj (PL/Vision OBJect) package provides a programmatic interface to the PL/SQL objects stored in the ALL_OBJECTS data dictionary view. See Chapter 11 for details.

5.20.1. Tracing PLVobj activity

PROCEDURE display;

Turns on display of information about activity occurring in PLVobj.

PROCEDURE nodisplay;

Turns off display of PLVobj activity.

FUNCTION displaying RETURN BOOLEAN;

Returns TRUE if showing activity in PLVobj.

5.20.2. General constants and exceptions

no_name_specified EXCEPTION;

Exception raised when you try to perform an operation but have not specified the name of the object (the "current object" has not been set).

c_pkg_spec CONSTANT VARCHAR2(1) := 'S';
c_pkg_body CONSTANT VARCHAR2(1) := 'B';
c_entire_pkg CONSTANT VARCHAR2(2) := 'SB';
c_proc CONSTANT VARCHAR2(2) := 'P';
c_func CONSTANT VARCHAR2(2) := 'F';

Names for the different types of program units. You can use these in calls to set_type or simply pass the literal values as part of a single type-name string.

c_procedure CONSTANT VARCHAR2(30) := 'PROCEDURE';
c_function CONSTANT VARCHAR2(30) := 'FUNCTION';
c_synonym CONSTANT VARCHAR2(30) := 'SYNONYM';
c_package CONSTANT VARCHAR2(30) := 'PACKAGE';
c_package_body CONSTANT VARCHAR2(30) := 'PACKAGE BODY';

Full names of program unit types as they are found in ALL_OBJECTS.

5.20.3. Setting the current object

PROCEDURE setcurr
   (name_in IN  VARCHAR2, type_in IN VARCHAR2 := NULL);

Sets the current object for other PLVobj modules. ...