Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
DBMS_METADATA , 6 of 11
SET_PARSE_ITEM
enables output parsing by specifying an object attribute to be parsed and returned. It should only be used in conjunction with FETCH_DDL
.
PROCEDURE set_parse_item (handle IN NUMBER, name IN VARCHAR2);
Parameter | Description |
---|---|
|
The handle returned from |
|
The name of the object attribute to be parsed and returned. See Table 28-9 for the attribute object type, name, and meaning. |
INVALID_ARGVAL
. A NULL
or invalid value was supplied for an input parameter. The error message text identifies the parameter.
INVALID_OPERATION
. SET_PARSE_ITEM
was called after the first call to FETCH_xxx
for the OPEN
context. After the first call to FETCH_xxx
is made, no further calls to SET_PARSE_ITEM
are permitted.
INCONSISTENT_ARGS
. The attribute name is not valid for the object type associated with the OPEN
context.
By default fetch_ddl
returns object metadata as creation DDL. By calling SET_PARSE_ITEM,
you can request that individual attributes of the object be returned also, to avoid the tedious process of parsing SQL text. This is useful when fetching objects based on the value of a returned object, for example, fetching indexes for a returned table.
You can call SET_PARSE_ITEM
multiple times to ask for multiple items to be parsed and returned. Parsed items are returned in the sys.ku$_parsed_items
nested table. See the example using sys.ku$_parsed_items
.
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|