Oracle9i Supplied PL/SQL Packages and Types Reference
Release 1 (9.0.1)

Part Number A89852-02
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to next page

28
DBMS_METADATA

With DBMS_METADATA you can retrieve complete database object definitions (metadata) from the dictionary by specifying:

DBMS_METADATA provides the following retrieval interfaces:

This chapter discusses the following topics:

Summary of DBMS_METADATA Subprograms

Table 28-1 DBMS_METADATA Package Subprograms
Subprogram  Description 

"OPEN Procedure" 

Specifies the type of object to be retrieved, the version of its metadata, and the object model. 

"SET_FILTER Procedure" 

Specifies restrictions on the objects to be retrieved, for example, the object name or schema. 

"SET_COUNT Procedure" 

Specifies the maximum number of objects to be retrieved in a single FETCH_xxx call. 

"GET_QUERY Procedure" 

Returns the text of the queries that are used by FETCH_xxx. 

"SET_PARSE_ITEM Procedure" 

Enables output parsing by specifying an object attribute to be parsed and returned. 

"ADD_TRANSFORM Procedure" 

Specifies a transform that FETCH_xxx applies to the XML representation of the retrieved objects. 

"SET_TRANSFORM_PARAM Procedure" 

Specifies parameters to the XSL-T stylesheet identified by transform_handle. 

"FETCH_xxx Procedure" 

Returns metadata for objects meeting the criteria established by OPEN, SET_FILTER, SET_COUNT, ADD_TRANSFORM, and so on. 

"CLOSE Procedure" 

Invalidates the handle returned by OPEN and cleans up the associated state.  

"GET_XML and GET_DDL Functions" 

Returns the metadata for the specified object as XML or DDL. 


Go to previous page Go to next page
Oracle
Copyright © 1996-2001, Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback