skip to content »

ik-kem.ru

111 xxx

If left NULL and the URL is internal to the database (that is, it begins with /oradb/), then the encoding is assumed to be the database character set. The version of the metadata is embedded in the XML.

111 xxx-78111 xxx-40111 xxx-29111 xxx-86

SET_FILTER ( handle IN NUMBER, name IN VARCHAR2, value IN VARCHAR2, object_type_path IN VARCHAR2 DEFAULT NULL); DBMS_METADATA.GET_DDL ( object_type IN VARCHAR2, name IN VARCHAR2, schema IN VARCHAR2 DEFAULT NULL, version IN VARCHAR2 DEFAULT 'COMPATIBLE', model IN VARCHAR2 DEFAULT 'ORACLE', transform IN VARCHAR2 DEFAULT 'DDL') RETURN CLOB; DBMS_METADATA.GET_DEPENDENT_XML ( object_type IN VARCHAR2, base_object_name IN VARCHAR2, base_object_schema IN VARCHAR2 DEFAULT NULL, version IN VARCHAR2 DEFAULT 'COMPATIBLE', model IN VARCHAR2 DEFAULT 'ORACLE', transform IN VARCHAR2 DEFAULT NULL, object_count IN NUMBER DEFAULT 10000) RETURN CLOB; DBMS_METADATA.This results in any shared server process that is serving a session running the package to effectively become a default, dedicated server for the life of the session.You should ensure that sufficient shared servers are configured when the package is used and that the number of servers is not artificially limited by too small a value for the CREATE TYPE sys.ku$_parsed_item AS OBJECT ( item VARCHAR2(30), value VARCHAR2(4000), object_row NUMBER ) / CREATE PUBLIC SYNONYM ku$_parsed_item FOR sys.ku$_parsed_item; CREATE TYPE sys.ku$_parsed_items IS TABLE OF sys.ku$_parsed_item / CREATE PUBLIC SYNONYM ku$_parsed_items FOR sys.ku$_parsed_items; CREATE TYPE sys.ku$_ddl AS OBJECT ( ddl Text CLOB, parsed Item sys.ku$_parsed_items ) / CREATE PUBLIC SYNONYM ku$_ddl FOR sys.ku$_ddl; CREATE TYPE sys.ku$_ddls IS TABLE OF sys.ku$_ddl / CREATE PUBLIC SYNONYM ku$_ddls FOR sys.ku$_ddls; CREATE TYPE sys.ku$_multi_ddl AS OBJECT ( object_row NUMBER, ddls sys.ku$_ddls ) / CREATE OR REPLACE PUBLIC SYNONYM ku$_multi_ddl FOR sys.ku$_multi_ddl; CREATE TYPE sys.ku$_multi_ddls IS TABLE OF sys.ku$_multi_ddl; / CREATE OR REPLACE PUBLIC SYNONYM ku$_multi_ddls FOR sys.ku$_multi_ddls; CREATE TYPE sys.ku$_Error Line IS OBJECT ( error Number NUMBER, error Text VARCHAR2(2000) ) / CREATE PUBLIC SYNONYM ku$_Error Line FOR sys.ku$_Error Line; CREATE TYPE sys.ku$_Error Lines IS TABLE OF sys.ku$_Error Line / CREATE PUBLIC SYNONYM ku$Error Lines FOR sys.ku$_Error Lines; CREATE TYPE sys.ku$_Submit Result AS OBJECT ( ddl sys.ku$_ddl, error Lines sys.ku$_Error Lines ); / CREATE TYPE sys.ku$_Submit Results IS TABLE OF sys.ku$_Submit Result / CREATE PUBLIC SYNONYM ku$_Submit Results FOR sys.ku$_Submit Results; The name of the Globalization Support character set in which the stylesheet pointed to by name is encoded. If left NULL and the URL is external to the database, UTF-8 encoding is assumed. The encoding of the XML document is embedded in its CLOB or XMLType representation.GET_DEPENDENT_DDL ( object_type IN VARCHAR2, base_object_name IN VARCHAR2, base_object_schema IN VARCHAR2 DEFAULT NULL, version IN VARCHAR2 DEFAULT 'COMPATIBLE', model IN VARCHAR2 DEFAULT 'ORACLE', transform IN VARCHAR2 DEFAULT 'DDL', object_count IN NUMBER DEFAULT 10000) RETURN CLOB; DBMS_METADATA.

GET_GRANTED_XML ( object_type IN VARCHAR2, grantee IN VARCHAR2 DEFAULT NULL, version IN VARCHAR2 DEFAULT 'COMPATIBLE', model IN VARCHAR2 DEFAULT 'ORACLE', transform IN VARCHAR2 DEFAULT NULL, object_count IN NUMBER DEFAULT 10000) RETURN CLOB; DBMS_METADATA.

For nested tables, the object name is the storage table name.

The base object is the top-level table to which the table data belongs.

SET_FILTER ( handle IN NUMBER, name IN VARCHAR2, value IN BOOLEAN DEFAULT TRUE, object_type_path IN VARCHAR2 DEFAULT NULL); DBMS_METADATA.

SET_FILTER ( handle IN NUMBER, name IN VARCHAR2, value IN NUMBER, object_type_path IN VARCHAR2 DEFAULT NULL); it applies to, its name, its datatype (text or Boolean) and its meaning or effect (including its default value, if any).

You can follow any responses to this entry through the RSS 2.0 feed.