December 2002
Intermediate to advanced
928 pages
85h 29m
English
PROCEDURE DBMS_METADATA.OPEN
(object_type IN VARCHAR2,
version IN VARCHAR2 DEFAULT 'COMPATIBLE',
model IN VARCHAR2 DEFAULT 'ORACLE')
RETURN NUMBER;
Specifies object_type, version, and object model and returns a context handle used in subsequent calls.
PROCEDURE DBMS_METADATA.SET_FILTER
(handle IN NUMBER,
name IN VARCHAR2,
value IN {VARCHAR2 | BOOLEAN DEFAULT TRUE});
Specifies restrictions on objects to be retrieved. The name parameter refers to the name of a filter, as explained in the Oracle documentation.
PROCEDURE DBMS_METADATA.SET_COUNT
(handle IN NUMBER,
value IN NUMBER);
Specifies the maximum number of objects (value) to be retrieved with a FETCH_* procedure.
PROCEDURE DBMS_METADATA.GET_QUERY
(handle IN NUMBER)
RETURN VARCHAR2;
Returns the text of queries used by the FETCH_* procedure.
PROCEDURE DBMS_METADATA.SET_PARSE_ITEM
(handle IN NUMBER,
name IN VARCHAR2);
Specifies an output attribute (name) to be parsed and returned with the FETCH_DDL procedure.
PROCEDURE DBMS_METADATA.ADD_TRANSFORMATION
(handle IN NUMBER,
name IN VARCHAR2,
encoding IN VARCHAR2 DEFAULT NULL)
RETURN NUMBER;
Requests that a transformation be applied to the XML representation of objects retrieved. Returns a handle to the transformed representation.
PROCEDURE DBMS_METADATA.SET_TRANSFORM_PARAM
(transform_handle IN NUMBER,
name IN VARCHAR2,
value IN {VARCHAR2 | BOOLEAN DEFAULT TRUE});
Specifies parameters to the XSLT stylesheet identified by transform_handle used to modify output of the transformation. ...