The DBMS_XDB_CONSTANTS package provides an interface to commonly used constants. Users should use constants instead of dynamic strings to avoid typographical errors.
This chapter contains the following topics:
Owned by XDB, the DBMS_XDB_CONSTANTS package must be created by SYS or XDB. The EXECUTE privilege is granted to PUBLIC. Subprograms in this package are executed using the privileges of the current user.
This table lists the DBMS_XDB_CONSTANTS subprograms and briefly describes them.
Table 189-1 DBMS_XDB_CONSTANTS Package Subprograms
| Subprograms | Description |
|---|---|
|
Returns |
|
|
Returns |
|
|
Returns |
|
|
Returns |
|
|
Returns |
|
|
Returns |
|
|
Returns |
|
|
Returns |
|
|
Returns |
|
|
Returns |
|
|
Returns |
|
|
Returns |
|
|
Returns |
|
|
Returns |
|
|
Returns |
|
|
Returns |
|
|
Returns |
|
|
Returns |
|
|
Returns |
|
|
Returns |
|
|
Returns |
|
|
Returns |
|
|
Returns |
|
|
Returns |
|
|
Returns |
|
|
Returns |
|
|
Returns |
|
|
Returns |
|
|
Returns |
|
|
Returns |
|
|
Returns |
|
|
Returns |
|
|
Returns |
This function returns 'AL32UTF8'.
Syntax
DBMS_XDB_CONSTANTS.ENCODING_DEFAULT RETURN VARCHAR2 DETERMINISTIC;
Return Value
'AL32UTF8'
This function returns 'WE8ISO8859P1'.
Syntax
DBMS_XDB_CONSTANTS.ENCODING_ISOLATIN1 RETURN VARCHAR2 DETERMINISTIC;
Return Value
'WE8ISO8859P1'
This function returns 'AL32UTF8'.
Syntax
DBMS_XDB_CONSTANTS.ENCODING_UTF8 RETURN VARCHAR2 DETERMINISTIC;
Return Value
'AL32UTF8'
This function returns 'WE8MSWIN1252'.
Syntax
DBMS_XDB_CONSTANTS.ENCODING_WIN1252 RETURN VARCHAR2 DETERMINISTIC;
Return Value
'WE8MSWIN1252'
This function returns 'http://xmlns.oracle.com/xdb/acl.xsd'.
Syntax
DBMS_XDB_CONSTANTS.NAMESPACE_ACL RETURN VARCHAR2 DETERMINISTIC;
Return Value
'http://xmlns.oracle.com/xdb/acl.xsd'
This function returns 'http://xmlns.oracle.com/xdbuserMetaData'.
Syntax
DBMS_XDB_CONSTANTS.NAMESPACE_METADATA RETURN VARCHAR2 DETERMINISTIC;
Return Value
'http://xmlns.oracle.com/xdbuserMetaData'
This function returns 'http://xmlns.oracle.com'.
Syntax
DBMS_XDB_CONSTANTS.NAMESPACE_ORACLE RETURN VARCHAR2 DETERMINISTIC;
Return Value
'http://xmlns.oracle.com'
This function returns 'http://xmlns.oracle.com/xdb'.
Syntax
DBMS_XDB_CONSTANTS.NAMESPACE_ORACLE_XDB RETURN VARCHAR2 DETERMINISTIC;
Return Value
'http://xmlns.oracle.com/xdb'
This function returns '/XDBResource.xsd'
Syntax
DBMS_XDB_CONSTANTS.NAMESPACE_RESOURCE RETURN VARCHAR2 DETERMINISTIC;
Return Value
'http://xmlns.oracle.com/xdb/XDBResource.xsd
This function returns 'http://xmlns.oracle.com/resourceEvent'.
Syntax
DBMS_XDB_CONSTANTS.NAMESPACE_RESOURCE_EVENT RETURN VARCHAR2 DETERMINISTIC;
Return Value
'http://xmlns.oracle.com/resourceEvent'
This function returns 'http://xmlns.oracle.com/XDBResConfig.xsd'.
Syntax
DBMS_XDB_CONSTANTS.NAMESPACE_RESOURCE_CONFIG RETURN VARCHAR2 DETERMINISTIC;
Return Value
'http://xmlns.oracle.com/XDBResConfig.xsd'
This function returns 'http://xmlns.oracle.com/xdb/XDBSchema.xsd'.
Syntax
DBMS_XDB_CONSTANTS.NAMESPACE_XDBSCHEMA RETURN VARCHAR2 DETERMINISTIC;
Return Value
'http://xmlns.oracle.com/xdb/XDBSchema.xsd'
This function returns 'http://xmlns.oracle.com/xdb/xdiff.xsd'.
Syntax
DBMS_XDB_CONSTANTS.NAMESPACE_XMLDIFF RETURN VARCHAR2 DETERMINISTIC;
Return Value
'http://xmlns.oracle.com/xdb/xdiff.xsd'
This function returns 'http://www.w3.org/2001/XMLSchema-instance'.
Syntax
DBMS_XDB_CONSTANTS.NAMESPACE_XMLINSTANCE RETURN VARCHAR2 DETERMINISTIC;
Return Value
'http://www.w3.org/2001/XMLSchema-instance'
This function returns 'http://www.w3.org/2001/XMLSchema'.
Syntax
DBMS_XDB_CONSTANTS. NAMESPACE_XMLSCHEMA RETURN VARCHAR2 DETERMINISTIC;
Return Value
'http://www.w3.org/2001/XMLSchema'
This function returns 'xmlns:acl= 'http://xmlns.oracle.com/acs.xsd'.
Syntax
DBMS_XDB_CONSTANTS.NSPREFIX_ACL_ACL RETURN VARCHAR2 DETERMINISTIC;
Return Value
'xmlns:acl= 'http://xmlns.oracle.com/acs.xsd'
This function returns ''xmlns:rc="http://xmlns.oracle.com/xdb/XDBResConfig.xsd"'.
Syntax
DBMS_XDB_CONSTANTS.NSPREFIX_RESCONFIG_RC RETURN VARCHAR2 DETERMINISTIC;
Return Value
Returns ''xmlns:rc="http://xmlns.oracle.com/xdb/XDBResConfig.xsd"'
This function returns 'xmlns:r="http://xmlns.oracle.com/XDBResource.xsd'.
Syntax
DBMS_XDB_CONSTANTS.NSPREFIX_RESOURCE_R RETURN VARCHAR2 DETERMINISTIC;
Return Value
'xmlns:r="http://xmlns.oracle.com/XDBResource.xsd'
This function returns 'http://xmlns.oracle.com/xdb'.
Syntax
DBMS_XDB_CONSTANTS.NSPREFIX_XDB_XDB RETURN VARCHAR2 DETERMINISTIC;
Return Value
'http://xmlns.oracle.com/xdb'
This function returns 'xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"'.
Syntax
DBMS_XDB_CONSTANTS.NSPREFIX_XMLINSTANCE_XSI RETURN VARCHAR2 DETERMINISTIC;
Return Value
'xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"'
This function returns 'xmlns:xd="http://xmlns.oracle.com/xdb/xdiff.xsd"'.
Syntax
DBMS_XDB_CONSTANTS.NSPREFIX_XMLDIFF_XD RETURN VARCHAR2 DETERMINISTIC;
Return Value
'xmlns:xd="http://xmlns.oracle.com/xdb/xdiff.xsd"'
This function returns 'xmlns:xsd="http://www.w3.org/2001/XMLSchema"'.
Syntax
DBMS_XDB_CONSTANTS.NSPREFIX_XMLSCHEMA_XSD RETURN VARCHAR2 DETERMINISTIC;
Return Value
'xmlns:xsd="http://www.w3.org/2001/XMLSchema"'
This function returns 'http://xmlns.oracle.com/xdb/acl.xsd'.
Syntax
DBMS_XDB_CONSTANTS.SCHEMAURL_ACL RETURN VARCHAR2 DETERMINISTIC;
Return Value
'http://xmlns.oracle.com/xdb/acl.xsd'
This function returns 'http://xmlns.oracle.com/xdb/acl.xsd#acl'.
Syntax
DBMS_XDB_CONSTANTS.SCHEMAELEM_RES_ACL RETURN VARCHAR2 DETERMINISTIC;
Return Value
'http://xmlns.oracle.com/xdb/acl.xsd#acl'
This function returns 'http://xmlns.oracle.com/xdb/XDBSchema.xsd#binary'.
Syntax
DBMS_XDB_CONSTANTS.SCHEMAELEM_RESCONTENT_BINARY RETURN VARCHAR2 DETERMINISTIC;
Return Value
'http://xmlns.oracle.com/xdb/XDBSchema.xsd#binary'
This function returns 'http://xmlns.oracle.com/xdb/XDBSchema.xsd#text'.
Syntax
DBMS_XDB_CONSTANTS.SCHEMAELEM_RESCONTENT_TEXT RETURN VARCHAR2 DETERMINISTIC;
Return Value
'http://xmlns.oracle.com/xdb/XDBSchema.xsd#text'
This function returns 'http://xmlns.oracle.com/xdb/XDBResource.xsd'.
Syntax
DBMS_XDB_CONSTANTS.SCHEMAURL_RESOURCE RETURN VARCHAR2 DETERMINISTIC;
Return Value
'http://xmlns.oracle.com/xdb/XDBResource.xsd'
This function returns 'http://xmlns.oracle.com/xdb/XDBSchema.xsd'.
Syntax
DBMS_XDB_CONSTANTS.SCHEMAURL_XDBSCHEMA RETURN VARCHAR2 DETERMINISTIC;
Return Value
'http://xmlns.oracle.com/xdb/XDBSchema.xsd'
This function returns 'xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xdb="http://xmlns.oracle.com/xdb'.
Syntax
DBMS_XDB_CONSTANTS.XDBSCHEMA_PREFIXES RETURN VARCHAR2 DETERMINISTIC;
Return Value
'xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xdb="http://xmlns.oracle.com/xdb'
This function returns 'attribute'.
Syntax
DBMS_XDB_CONSTANTS.XSD_ATTRIBUTE RETURN VARCHAR2 DETERMINISTIC;
Return Value
'attribute'
This function returns 'complexType'.
Syntax
DBMS_XDB_CONSTANTS.XSD_COMPLEX_TYPE RETURN VARCHAR2 DETERMINISTIC;
Return Value
'complexType'
This function returns 'element'.
Syntax
DBMS_XDB_CONSTANTS. XSD_ELEMENT RETURN VARCHAR2 DETERMINISTIC;
Return Value
'element'