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. ...
Get Advanced Oracle PL/SQL Programming with Packages now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.