Skip to Main Content
Oracle in a Nutshell
book

Oracle in a Nutshell

by Rick Greenwald, David C. Kreines
December 2002
Intermediate to advanced content levelIntermediate to advanced
928 pages
85h 29m
English
O'Reilly Media, Inc.
Content preview from Oracle in a Nutshell

Calls

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. ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle Internals

Oracle Internals

Donald K. Burleson
Oracle PL/SQL

Oracle PL/SQL

Lewis Cunningham
Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Rick Greenwald, Robert Stackowiak, Jonathan Stern

Publisher Resources

ISBN: 0596003366Errata Page