181 DBMS_XDB

Note:

The DBMS_XDB package subprograms and constants are deprecated with Oracle Database 12c. While all features continue to be supported for backward compatibility, Oracle recommends that you use the alternative procedures provided in each case. For more information, see Deprecated Subprograms and Constants.

The DBMS_XDB package supports the following features:

This chapter contains the following topics:

Using DBMS_XDB

This section contains topics which relate to using the DBMS_XDB package.

Overview

The DBMS_XDB package supports the following features:

Deprecated Subprograms

Note:

Oracle recommends that you do not use deprecated subprograms in new applications. Support for deprecated features is for backward compatibility only and may be terminated in future releases.

All subprograms in the DBMS_XDB package are deprecated with Oracle Database 12c and substituted by the alternative subprograms with the same names in either the DBMS_XDB_CONFIG package or the DBMS_XDB_REPOS package as listed in the table.

Table 181-1 DBMS_XDB Deprecated Subprograms and their Altenatives

DBMS_XDB (Deprecated) DBMS_XDB_CONFIG DBMS_XDB_REPOS

ACLCHECKPRIVILEGES Function

 

ACLCHECKPRIVILEGES Function

ADDHTTPEXPIREMAPPING Procedure

ADDHTTPEXPIREMAPPING Procedure

 

ADDMIMEMAPPING Procedure

ADDMIMEMAPPING Procedure

 

ADDSCHEMALOCMAPPING Procedure

ADDSCHEMALOCMAPPING Procedure

 

ADDSERVLET Procedure

ADDSERVLET Procedure

 

ADDSERVLETMAPPING Procedure

ADDSERVLETMAPPING Procedure

 

ADDSERVLETSECROLE Procedure

ADDSERVLETSECROLE Procedure

 

ADDXMLEXTENSION Procedure

ADDXMLEXTENSION Procedure

 

APPENDRESOURCEMETADATA Procedure

 

APPENDRESOURCEMETADATA Procedure

CFG_GET Function

CFG_GET Function

 

CFG_REFRESH Procedure

CFG_REFRESH Procedure

 

CFG_UPDATE Procedure

CFG_UPDATE Procedure

 

CHANGEOWNER Procedure

 

CHANGEOWNER Procedure

CHANGEPRIVILEGES Function

 

CHANGEPRIVILEGES Function

CHECKPRIVILEGES Function

 

CHECKPRIVILEGES Function

CREATEFOLDER Function

 

CREATEFOLDER Function

CREATEOIDPATH Function

 

CREATEOIDPATH Function

CREATERESOURCE Functions

 

CREATERESOURCE Functions

DELETEHTTPEXPIREMAPPING Procedure

DELETEHTTPEXPIREMAPPING Procedure

 

DELETEMIMEMAPPING Procedure

DELETEMIMEMAPPING Procedure

 

DELETERESOURCE Procedure

 

DELETERESOURCE Procedure

DELETERESOURCEMETADATA Procedures

 

DELETERESOURCEMETADATA Procedures

DELETESCHEMALOCMAPPING Procedure

DELETESCHEMALOCMAPPING Procedure

 

DELETESERVLET Procedure

DELETESERVLET Procedure

 

DELETESERVLETMAPPING Procedure

DELETESERVLETMAPPING Procedure

 

DELETESERVLETSECROLE Procedure

DELETESERVLETSECROLE Procedure

 

DELETEXMLEXTENSION Procedure

DELETEXMLEXTENSION Procedure

 

ENABLEDIGESTAUTHENTICATION Procedure

ENABLEDIGESTAUTHENTICATION Procedure

 

EXISTSRESOURCE Function

 

EXISTSRESOURCE Function

GETACLDOCUMENT Function

 

GETACLDOCUMENT Function

GETCONTENTBLOB Function

 

GETCONTENTBLOB Function

GETCONTENTCLOB Function

 

GETCONTENTCLOB Function

GETCONTENTVARCHAR2 Function

 

GETCONTENTVARCHAR2 Function

GETCONTENTXMLREF Function

 

GETCONTENTXMLREF Function

GETCONTENTXMLTYPE Function

 

GETCONTENTXMLTYPE Function

GETFTPPORT Function

GETFTPPORT Function

 

GETHTTPPORT Function

GETHTTPPORT Function

 

GETLISTENERENDPOINT Procedure

GETLISTENERENDPOINT Procedure

 

GETLOCKTOKEN Procedure

 

GETLOCKTOKEN Procedure

GETRESOID Function

 

GETRESOID Function

GETXDB_TABLESPACE Function

 

GETXDB_TABLESPACE Function

HASBLOBCONTENT Function

 

HASBLOBCONTENT Function

HASCHARCONTENT Function

 

HASCHARCONTENT Function

HASXMLCONTENT Function

 

HASXMLCONTENT Function

HASXMLREFERENCE Function

 

HASXMLREFERENCE Function

ISFOLDER Function

 

ISFOLDER Function

LINK Procedures

 

LINK Procedures

LOCKRESOURCE Function

 

LOCKRESOURCE Function

PROCESSLINKS Procedure

 

PROCESSLINKS Procedure

PURGERESOURCEMETADATA Procedure

 

PURGERESOURCEMETADATA Procedure

RENAMERESOURCE Procedure

 

RENAMERESOURCE Procedure

SETACL Procedure

 

SETACL Procedure

SETFTPPORT Procedure

SETFTPPORT Procedure

 

SETHTTPPORT Procedure

SETHTTPPORT Procedure

 

SETLISTENERENDPOINT Procedure

SETLISTENERENDPOINT Procedure

 

SETLISTENERLOCALACCESS Procedure

SETLISTENERLOCALACCESS Procedure

 

SPLITPATH Procedure

 

SPLITPATH Procedure

TOUCHRESOURCE Procedure

 

TOUCHRESOURCE Procedure

UNLOCKRESOURCE Function

 

UNLOCKRESOURCE Function

UPDATERESOURCEMETADATA Procedures

 

UPDATERESOURCEMETADATA Procedures


Security Model

Owned by XDB, the DBMS_XDB 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. Subprograms that operate on the XDB Configuration will succeed only if the current user is SYS or XDB, or the current user has the XDBADMIN or DBA role.

Constants

All constants as described in Table 181-2, "DBMS_XDB Constants"are deprecated in Oracle Release 12c in that they are relocated to either the DBMS_XDB_CONFIG package or the DBMS_XDB_REPOS package. The specifics of transference in each case are detailed in the Relocated column.

Oracle recommends that you do not use constants in their DBMS_XDB context in new applications. Support for deprecated features is for backward compatibility only and may be terminated in future releases.

Table 181-2 DBMS_XDB Constants

Constant Type Value Description Relocated

DELETE_RESOURCE

NUMBER

1

Deletes a resource; fails if the resource has children.

DBMS_XDB_REPOS

DELETE_RECURSIVE

NUMBER

2

Deletes a resource and its children, if any.

DBMS_XDB_REPOS

DELETE_FORCE

NUMBER

3

Deletes the resource, even if the object it contains is invalid.

DBMS_XDB_REPOS

DELETE_RECURSIVE_FORCE

NUMBER

4

Deletes a resource and its children, if any, even if the object it contains is invalid.

DBMS_XDB_REPOS

DELETE_RES_METADATA_CASCADE

NUMBER

1

Deletes the corresponding row in the metadata table

DBMS_XDB_REPOS

DELETE_RES_METADATA_NOCASCADE

NUMBER

2

Does not delete the row in the metadata table

DBMS_XDB_REPOS

DEFAULT_LOCK_TIMEOUT CONSTANT

PLS_INTEGER

(60*60)

Default time (in seconds) after which lock will expire

DBMS_XDB_REPOS

LINK_TYPE_HARD

NUMBER

1

Type of link to be created (default)

DBMS_XDB_REPOS

LINK_TYPE_WEAK

NUMBER

2

Type of link to be created

DBMS_XDB_REPOS

LINK_TYPE_SYMBOLIC

NUMBER

3

Type of link to be created

DBMS_XDB_REPOS

ON_DENY_NEXT_CUSTOM

NUMBER

1

If access denied, the next custom authorization is tried

DBMS_XDB_CONFIG

ON_DENY_BASIC

NUMBER

2

If access denied, basic authentication is used

DBMS_XDB_CONFIG

XDB_ENDPOINT_HTTP

NUMBER

1

Defining listener for first HTTP port

DBMS_XDB_CONFIG

XDB_ENDPOINT_HTTP2

NUMBER

2

Defining listener for second HTTP port

DBMS_XDB_CONFIG

XDB_PROTOCOL_TCP

NUMBER

1

Defining listener for HTTP protocol

DBMS_XDB_CONFIG

XDB_PROTOCOL_TCPS

NUMBER

2

Defining listener for HTTPS protocol

DBMS_XDB_CONFIG


Summary of DBMS_XDB Subprograms

Table 181-3 DBMS_XDB Package Subprograms

Subprogram Description

ACLCHECKPRIVILEGES Function

Checks access privileges granted to the current user by specified ACL document on a resource whose owner is specified by the 'owner' parameter.

ADDHTTPEXPIREMAPPING Procedure

Adds to xdb$config a mapping of the URL pattern to an expiration date. This will control the Expire headers for URLs matching the pattern.

ADDMIMEMAPPING Procedure

Adds a mime mapping to the XDB configuration

ADDSCHEMALOCMAPPING Procedure

Adds a schema location mapping to the XDB configuration

ADDSERVLET Procedure

Adds a servlet to XDB configuration

ADDSERVLETMAPPING Procedure

Adds a servlet mapping to XDB configuration

ADDSERVLETSECROLE Procedure

Adds a security role REF to a specified servlet in the XDB configuration

ADDXMLEXTENSION Procedure

Adds adds an XML extension to the XDB configuration

APPENDRESOURCEMETADATA Procedure

Takes in user-defined metadata either as a REF to XMLTYPE or an XMLTYPE and adds it to the desired resource

CFG_GET Function

Retrieves the session's configuration information

CFG_REFRESH Procedure

Refreshes the session's configuration information to the latest configuration

CFG_UPDATE Procedure

Updates the configuration information

CHANGEOWNER Procedure

Changes the owner of the resource/s to the specified owner.

CHANGEPRIVILEGES Function

Adds a specified ACE to a specified resource's ACL

CHECKPRIVILEGES Function

Checks access privileges granted to the current user on the specified resource

CREATEFOLDER Function

Creates a new folder resource in the hierarchy

CREATEOIDPATH Function

Creates a virtual path to the resource based on object ID

CREATERESOURCE Functions

Creates a new resource

DELETEHTTPEXPIREMAPPING Procedure

Deletes from xdb$config all mappings of the URL pattern to an expiration date

DELETEMIMEMAPPING Procedure

Deletes the mime mapping from the XDB configuration

DELETERESOURCE Procedure

Deletes a resource from the hierarchy

DELETERESOURCEMETADATA Procedures

Deletes metadata from a resource (can be used for schema-based or nonschema-based metadata)

DELETESCHEMALOCMAPPING Procedure

Deletes the schema location mapping for the specified schema URL from the XDB configuration.

DELETESERVLET Procedure

Deletes a servlet from XDB configuration

DELETESERVLETMAPPING Procedure

Deletes the servlet mapping for the specified servlet name from the XDB configuration

DELETESERVLETSECROLE Procedure

Deletes the specified role from a servlet in the XDB configuration

DELETEXMLEXTENSION Procedure

Deletes the specified XML extension from the XDB configuration

ENABLEDIGESTAUTHENTICATION Procedure

Enables digest authentication

EXISTSRESOURCE Function

Determines if a resource is the hierarchy, based on its absolute path

GETACLDOCUMENT Function

Retrieves ACL document that protects resource given its path name

GETCONTENTBLOB Function

Retrieves the contents of a resource returned as a BLOB

GETCONTENTCLOB Function

Retrieves the contents of a resource returned as a CLOB

GETCONTENTVARCHAR2 Function

Retrieves the contents of a resource returned as a string

GETCONTENTXMLREF Function

Retrieves the contents of a resource returned as a a REF to an XMLTYPE

GETCONTENTXMLTYPE Function

Retrieves the contents of a resource returned as an XMLTYPE

GETFTPPORT Function

Gets the value of the current FTP port

GETHTTPPORT Function

Gets the value of the current HTTP port

GETHTTPREQUESTHEADER Function

Gets the values of the passed header

GETLISTENERENDPOINT Procedure

Retrieves the parameters of a listener end point corresponding to the XML DB HTTP server

GETLOCKTOKEN Procedure

Returns that resource's lock token for the current user given a path to a resource

GETPRIVILEGES Function

Gets all privileges granted to the current user on a specified resource

GETRESOID Function

Returns the object ID of the resource from its absolute path

GETXDB_TABLESPACE Function

Returns the current tablespace of the XDB (user)

HASBLOBCONTENT Function

Returns TRUE if the resource has BLOB content

HASCHARCONTENT Function

Returns TRUE if the resource has character content

HASXMLCONTENT Function

Returns TRUE if the resource has XML content

HASXMLREFERENCE Function

Returns TRUE if the resource has REF to XML content

ISFOLDER Function

Returns TRUE if the resource is a folder or container

LINK Procedures

Creates a link to an existing resource

LOCKRESOURCE Function

Gets a WebDAV-style lock on that resource given a path to that resource

PROCESSLINKS Procedure

Processes document links in the specified resource

PURGERESOURCEMETADATA Procedure

Deletes all user metadata from a resource

RENAMERESOURCE Procedure

Renames the XDB resource

SETACL Procedure

Sets the ACL on a specified resource

SETFTPPORT Procedure

Sets the FTP port to a new value

SETHTTPPORT Procedure

Sets the HTTP port to a new value

SETLISTENERENDPOINT Procedure

Sets the parameters of a listener end point corresponding to the XML DB HTTP server

SETLISTENERLOCALACCESS Procedure

Restricts all listener end points of the XML DB HTTP server to listen either only on the localhost interface or on both localhost and non-localhost interfaces

SPLITPATH Procedure

Splits the path into a parentpath and childpath

TOUCHRESOURCE Procedure

Changes the modification time of the resource to the current time

UNLOCKRESOURCE Function

Unlocks the resource given a lock token and resource path

UPDATERESOURCEMETADATA Procedures

Updates metadata for a resource


ACLCHECKPRIVILEGES Function

Note:

This procedure is deprecated in Release 12c. This functionality is replaced by a subprogram of the same name in the DBMS_XDB_REPOS package - the ACLCHECKPRIVILEGES Function.

This function checks access privileges granted to the current user by specified ACL document by the OWNER of the resource. Returns positive integer if all privileges are granted.

Syntax

DBMS_XDB.ACLCHECKPRIVILEGES(
   acl_path  IN  VARCHAR2,
   owner     IN  VARCHAR2,
   privs     IN  xmltype)
 RETURN PLS_INTEGER;

Parameters

Table 181-4 ACLCHECKPRIVILEGES Function Parameters

Parameter Description

acl_path

Absolute path in the Hierarchy for ACL document

owner

Resource owner name; the pseudo user "DAV:owner" is replaced by this user during ACL privilege resolution

privs

An XMLType instance of the privilege element specifying the requested set of access privileges. See description for CHECKPRIVILEGES Function.


ADDHTTPEXPIREMAPPING Procedure

Note:

This procedure is deprecated in Release 12c. This functionality is replaced by a subprogram of the same name in the DBMS_XDB_CONFIG package - the ADDHTTPEXPIREMAPPING Procedure.

This procedure adds to xdb$config a mapping of the URL pattern to an expiration date. This will control the Expire headers for URLs matching the pattern.

Syntax

DBMS_XDB.ADDHTTPEXPIREMAPPING (
     pattern    IN    VARCHAR2,
     expire     IN    VARCHAR2);

Parameters

Table 181-5 ADDHTTPEXPIREMAPPING Procedure Parameters

Parameter Description

pattern

URL pattern (only * accepted as wildcards)

expire

Expiration directive, follows the ExpireDefault in Apache's mod_expires:

base [plus] (num type)*
-- base: now | modification
-- type: year|years|month|months|week|weeks|day|days|
minute|minutess|second|seconds

Examples

DBMS_XDB.ADDHTTPEXPIREMAPPING ('/public/test1/*', 'now plus 4 weeks');
DBMS_XDB.ADDHTTPEXPIREMAPPING (
             '/public/test2/*', 'modification plus 1 day 30 seconds');

ADDMIMEMAPPING Procedure

Note:

This procedure is deprecated in Release 12c. This functionality is replaced by a subprogram of the same name in the DBMS_XDB_CONFIG package - the ADDMIMEMAPPING Procedure.

This procedure adds the following mime mapping to XDB configuration:

<mime-mapping>
<extension>extension</extension>
<mime-type>mimetype</mime-type>
</mime-mapping>

Syntax

DBMS_XDB.ADDMIMEMAPPING(
     extension    IN   VARCHAR2,
     mimetype     IN   VARCHAR2);

Parameters

Table 181-6 ADDMIMEMAPPING Procedure Parameters

Parameter Description

extension

Extension for which a mime type is being added

mimetype

Mime type


ADDSCHEMALOCMAPPING Procedure

Note:

This procedure is deprecated in Release 12c. This functionality is replaced by a subprogram of the same name in the DBMS_XDB_CONFIG package - the ADDMIMEMAPPING Procedure.

This procedure adds the following schema location mapping to the XDB configuration:

<schemaLocation-mapping>
     <namespace>namespace</namespace>
     <element>element</element>
      <schemaURL>schemaURL</schemaURL>
</schemaLocation-mapping>

Syntax

DBMS_XDB.ADDSCHEMALOCMAPPING(
     namespace    IN   VARCHAR2,
     element      IN   VARCHAR2,
     schemaURL    IN   VARCHAR2);

Parameters

Table 181-7 ADDSCHEMALOCMAPPING Procedure Parameters

Parameter Description

namespace

Namespace

element

Element

schemaURL

Schema URL


ADDSERVLET Procedure

Note:

This procedure is deprecated in Release 12c. This functionality is replaced by a subprogram of the same name in the DBMS_XDB_CONFIG package - the ADDSERVLET Procedure.

This procedure adds the following servlet to XDB configuration:

<servlet>
     <servlet-name>name</servlet-name>     <servlet-language>language</servlet-language>
     <display-name>dispname</display-name>
     <description>descript</description>
     <servlet-class>class</servlet-class>
     <servlet-schema>schema</servlet-schema>
</servlet>

Syntax

DBMS_XDB.ADDSERVLET(
     name       IN   VARCHAR2,
    language    IN   VARCHAR2,
    dispname    IN   VARCHAR2,
    icon        IN   VARCHAR2 := NULL,
    descript    IN   VARCHAR2 := NULL,
    class       IN   VARCHAR2 := NULL,
    jspfile     IN   VARCHAR2 := NULL,
    plsql       IN   VARCHAR2 := NULL);

Parameters

Table 181-8 ADDSERVLET Procedure Parameters

Parameter Description

name

Servlet name

language

Must be one of "C", "Java", "PL/SQL"

dispname

Display name

icon

Icon

descript

Description

class

The class / jspfile / plsql function corresponding to this servlet. The first non-NULL argument amongst these three is chosen, and the others are treated as NULL.

jspfile

The class / jspfile / plsql function corresponding to this servlet. The first non-NULL argument amongst these three is chosen, and the others are treated as NULL.

plsql

The class / jspfile / plsql function corresponding to this servlet. The first non-NULL argument amongst these three is chosen, and the others are treated as NULL.

schema

Schema


ADDSERVLETMAPPING Procedure

Note:

This procedure is deprecated in Release 12c. This functionality is replaced by a subprogram of the same name in the DBMS_XDB_CONFIG package - the ADDSERVLETMAPPING Procedure.

This procedure adds the following servlet mapping to XDB configuration:

<servlet-mapping>     <servlet-pattern>pattern</servlet-pattern>     <servlet-name>name</servlet-name></servlet-mapping>

Syntax

DBMS_XDB.ADDSERVLETMAPPING(
     pattern   IN   VARCHAR2,     name      IN   VARCHAR2);

Parameters

Table 181-9 ADDSERVLETMAPPING Procedure Parameters

Parameter Description

pattern

Sservlet pattern

name

Servlet name


ADDSERVLETSECROLE Procedure

Note:

This procedure is deprecated in Release 12c. This functionality is replaced by a subprogram of the same name in the DBMS_XDB_CONFIG package - the ADDSERVLETSECROLE Procedure.

This procedure adds the following security role REF to a specified servlet in XDB configuration:

<security-role-ref>
     <role-name>rolename</role-name>
     <role-link>rolelink</role-link>
     <description>descript</description>
</security-role-ref>

Syntax

DBMS_XDB.ADDSERVLETSECROLE(
     servname    IN   VARCHAR2,     rolename    IN   VARCHAR2,     rolelink    IN   VARCHAR2,     descript    IN   VARCHAR2 := NULL);

Parameters

Table 181-10 ADDSERVLETSECROLE Procedure Parameters

Parameter Description

servname

Sservlet name

rolename

Role name

rolelink

Role link

descript

Description


ADDXMLEXTENSION Procedure

Note:

This procedure is deprecated in Release 12c. This functionality is replaced by a subprogram of the same name in the DBMS_XDB_CONFIG package - the ADDXMLEXTENSION Procedure.

This procedure adds the following XML extension to the XDB configuration under <xml-extensions>:

<extension>extension</extension>

Syntax

DBMS_XDB.ADDXMLEXTENSION(
     extension    IN   VARCHAR2);

Parameters

Table 181-11 ADDXMLEXTENSION Procedure Parameters

Parameter Description

extension

XML extension to be added


APPENDRESOURCEMETADATA Procedure

Note:

This procedure is deprecated in Release 12c. This functionality is replaced by a subprogram of the same name in the DBMS_XDB_REPOS package - the APPENDRESOURCEMETADATA Procedure.

This procedure takes in user-defined metadata either as a REF to XMLTYPE or an XMLTYPE and adds it to the desired resource.

Syntax

DBMS_XDB.APPENDRESOURCEMETADATA (
 abspath   IN  VARCHAR2, 
 metadata  IN  XMLTYPE);

DBMS_XDB.APPENDRESOURCEMETADATA (
 abspath   IN  VARCHAR2, 
 metadata  IN  REF SYS.XMLTYPE);

Parameters

Table 181-12 APPENDRESOURCEMETADATA Procedure

Parameter Description

abspath

Absolute path of the resource

metadata

Metadata can be schema based or nonschema-based. Schema-based metadata is stored in its own table.


Usage Notes

  • In the case in which a REF is passed in, the procedure stores the REF in the resource, and the metadata is stored in a separate table. In this case you are responsible for populating the RESID column for the metadata table. Note that theREF passed in must be unique. In other words, there must not be aREF with the same value in the resource metadata, as this would violate uniqueness of properties. An error is thrown if users attempt to add a REF that already exists.

  • In the case where the XMLTYPE is passed in, the data is parsed to determine if it is schema-based or not and stored accordingly.

CFG_GET Function

Note:

This procedure is deprecated in Release 12c. This functionality is replaced by a subprogram of the same name in the DBMS_XDB_CONFIG package - the CFG_GET Function.

This function retrieves the session's configuration information as an XMLType instance.

Syntax

DBMS_XDB.CFG_GET 
 RETURN SYS.XMLType;

CFG_REFRESH Procedure

Note:

This procedure is deprecated in Release 12c. This functionality is replaced by a subprogram of the same name in the DBMS_XDB_CONFIG package - the CFG_REFRESH Procedure.

This procedure refreshes the session's configuration information to the latest configuration.

Syntax

DBMS_XDB.CFG_REFRESH;

CFG_UPDATE Procedure

Note:

This procedure is deprecated in Release 12c. This functionality is replaced by a subprogram of the same name in the DBMS_XDB_CONFIG package - the CFG_UPDATE Procedure.

This procedure updates the configuration information and commits the change.

Syntax

DBMS_XDB.CFG_UPDATE(
   xdbconfig   IN  SYS.XMLTYPE);

Parameters

Table 181-13 CFG_UPDATE Procedure Parameters

Parameter Description

xdbconfig

The new configuration data


CHANGEOWNER Procedure

Note:

This procedure is deprecated in Release 12c. This functionality is replaced by a subprogram of the same name in the DBMS_XDB_REPOS package - the CHANGEOWNER Procedure.

This procedure changes the owner of the resource/s to the specified owner.

Syntax

DBMS_XDB.CHANGEOWNER(
     abspath    IN   VARCHAR2,
     owner      IN   VARCHAR2,
     recurse    IN   BOOLEAN := FALSE);

Parameters

Table 181-14 CHANGEOWNER Procedure Parameters

Parameter Description

abspath

Absolute path of the resource

owner

New owner for the resource

recurse

If TRUE, recursively change owner of all resources in the folder tree


CHANGEPRIVILEGES Function

Note:

This procedure is deprecated in Release 12c. This functionality is replaced by a subprogram of the same name in the DBMS_XDB_REPOS package - the CHANGEPRIVILEGES Function.

This function adds a specified ACE to a specified resource's ACL.

Syntax

DBMS_XDB.CHANGEPRIVILEGES(
   res_path   IN    VARCHAR2,
   ace        IN    xmltype)
 RETURN PLS_INTEGER;

Parameters

Table 181-15 CHANGEPRIVILEGES Function Parameters

Parameter Description

res_path

Path name of the resource for which privileges need to be changed

ace

An XMLType instance of the <ace> element which specifies the <principal>, the operation <grant> and the list of privileges


Return Values

A positive integer if the ACL was successfully modified.

Usage Notes

If no ACE with the same principal and the same operation (grant/deny) already exists in the ACL, the new ACE is added at the end of the ACL.

CHECKPRIVILEGES Function

Note:

This procedure is deprecated in Release 12c. This functionality is replaced by a subprogram of the same name in the DBMS_XDB_REPOS package - the CHECKPRIVILEGES Function.

This function checks access privileges granted to the current user on the specified resource.

Syntax

DBMS_XDB.CHECKPRIVILEGES(
   res_path   IN  VARCHAR2,
   privs      IN  xmltype)
 RETURN PLS_INTEGER;

Parameters

Table 181-16 CHECKPRIVILEGES Function Parameters

Parameter Description

res_path

Absolute path in the Hierarchy for resource

privs

An XMLType instance of the privilege element specifying the requested set of access privileges


Return Values

A positive integer if all requested privileges granted.

CREATEFOLDER Function

Note:

This procedure is deprecated in Release 12c. This functionality is replaced by a subprogram of the same name in the DBMS_XDB_REPOS package - the CREATEFOLDER Function.

This function creates a new folder resource in the hierarchy.

Syntax

DBMS_XDB.CREATEFOLDER(
   path   IN  VARCHAR2)
 RETURN BOOLEAN;

Parameters

Table 181-17 CREATEFOLDER Function Parameters

Parameter Description

path

Path name for the new folder


Return Values

TRUE if operation successful; FALSE, otherwise.

Usage Notes

The given path name's parent folder must already exist in the hierarchy: if '/folder1/folder2' is passed as the path parameter, then '/folder1' must already exist.

CREATEOIDPATH Function

Note:

This procedure is deprecated in Release 12c. This functionality is replaced by a subprogram of the same name in the DBMS_XDB_REPOS package - the CREATEOIDPATH Function.

This function creates a virtual path to the resource based on object ID.

Syntax

DBMS_XDB.CREATEOIDPATH(
   oid    IN   RAW)
 RETURN VARCHAR2;

Parameters

Table 181-18 CREATEOIDPATH Function Parameters

Parameter Description

oid

Object ID of the resource


CREATERESOURCE Functions

Note:

This procedure is deprecated in Release 12c. This functionality is replaced by a subprogram of the same name in the DBMS_XDB_REPOS package - the CREATERESOURCE Functions.

The functions create a new resource. The description of the overload options precede each version of the syntax

Syntax

Given a REF to an existing XMLType row, creates a resource whose contents point to that row. That row should not already exist inside another resource:

DBMS_XDB.CREATERESOURCE(
     abspath        IN  VARCHAR2,
     datarow        IN  REF SYS.XMLTYPE,
     createfolders  IN  BOOLEAN := FALSE)
 RETURN BOOLEAN;

Creates a resource with a specified BLOB as its contents, and specifies character set of the source BLOB:

DBMS_XDB.CREATERESOURCE(
     abspath        IN  VARCHAR2,
     data           IN  BLOB,
     csid           IN  NUMBER :=0,
     createfolders  IN  BOOLEAN := FALSE)
 RETURN BOOLEAN; 

Creates a resource with a specified BFILE as its contents, and specifies character set of the source BFILE:

DBMS_XDB.CREATERESOURCE ( 
     abspath        IN  VARCHAR2,
     data           IN  BFILE,
     csid           IN  NUMBER :=0,
     createfolders  IN  BOOLEAN := FALSE)
 RETURN BOOLEAN;

Creates a resource with a specified CLOB as its contents:

DBMS_XDB.CREATERESOURCE (
     abspath        IN  VARCHAR2,
     data           IN  CLOB,
     createfolders  IN  BOOLEAN := FALSE)
 RETURN BOOLEAN; 

Given a string, inserts a new resource into the hierarchy with the string as the contents:

DBMS_XDB.CREATERESOURCE (
   abspath        IN  VARCHAR2, 
   data           IN  VARCHAR2,
   schemaurl      IN  VARCHAR2 := NULL,
   elem           IN  VARCHAR2 := NULL)
 RETURN BOOLEAN; 

Given an XMLTYPE and a schema URL, inserts a new resource into the hierarchy with the XMLTYPE as the contents:

DBMS_XDB.CREATERESOURCE (
   abspath        IN  VARCHAR2, 
   data           IN  SYS.XMLTYPE,
   schemaurl      IN  VARCHAR2 := NULL,
   elem           IN  VARCHAR2 := NULL)
 RETURN BOOLEAN;

Parameters

Table 181-19 CREATERESOURCE Function Parameters

Parameter Description

abspath

Absolute path of the resource to create. The path name's parent folder must already exist in the hierarchy. In other words, if /foo/bar.txt is passed in, then folder /foo must already exist.

data

String buffer containing new resource's contents. The data is parsed to check if it contains a schema-based XML document, and the contents are stored as schema-based in the schema's default table. Otherwise, it is saved as binary data.

datarow

REF to an XMLType row to be used as the contents

csid

Character set id of the document. Must be a valid Oracle ID; otherwise returns an error.

If CSID is not specified, or if a zero CSID is specified, then the character set id of the document is determined as follows:

  • From the abspath extension, determine the resource's MIME type.

  • If the MIME type is */xml, then the encoding is detected based on Appendix F of the W3C XML 1.0 Reference at http://www.w3.org/TR/2000/REC-xml-20001006;

  • Otherwise, it is defaulted to the database character set.

createfolders

If TRUE, create the parent folders if they do not exist

schemaurl

For XML data, schema URL data conforms to (default NULL)

elem

Element name (default NULL)


Return Values

TRUE if operation successful; FALSE, otherwise.

DELETEHTTPEXPIREMAPPING Procedure

Note:

This procedure is deprecated in Release 12c. This functionality is replaced by a subprogram of the same name in the DBMS_XDB_CONFIG package - the DELETEHTTPEXPIREMAPPING Procedure.

This procedure deletes from xdb$config all mappings of the URL pattern to an expiration date.

Syntax

DBMS_XDB.DELETEHTTPEXPIREMAPPING(
     pattern  IN   VARCHAR2);

Parameters

Table 181-20 DELETEHTTPEXPIREMAPPING Procedure Parameters

Parameter Description

pattern

URL pattern (only * accepted as wildcards)


DELETEMIMEMAPPING Procedure

Note:

This procedure is deprecated in Release 12c. This functionality is replaced by a subprogram of the same name in the DBMS_XDB_CONFIG package - the CFG_GET Function.

This procedure deletes the mime mapping for a specified extension from the XDB configuration.

Syntax

DBMS_XDB.DELETEMIMEMAPPING(
     extension    IN   VARCHAR2);

Parameters

Table 181-21 DELETEMIMEMAPPING Procedure Parameters

Parameter Description

extension

Extension for which a mime type is to be deleted


DELETERESOURCE Procedure

Note:

This procedure is deprecated in Release 12c. This functionality is replaced by a subprogram of the same name in the DBMS_XDB_REPOS package - the DELETERESOURCE Procedure.

This procedure deletes a resource from the hierarchy.

Syntax

DBMS_XDB.DELETERESOURCE(
   path          IN      VARCHAR2,
   delete_option IN      PLS_INTEGER);

Parameters

Table 181-22 DELETERESOURCE Procedure Parameters

Parameter Description

path

Path name of the resource to delete

delete_option

The option that controls how a a resource is deleted; defined in Table 181-2:

  • DELETE_RESOURCE

  • DELETE_RECURSIVE

  • DELETE_FORCE

  • DELETE_RECURSIVE_FORCE


DELETERESOURCEMETADATA Procedures

Note:

This procedure is deprecated in Release 12c. This functionality is replaced by a subprogram of the same name in the DBMS_XDB_REPOS package - the DELETERESOURCEMETADATA Procedures.

This procedure takes in a resource by absolute path and removes either the schema-based metadata identified by the REF, or the metadata identified by the namespace and name combination, which can be either schema-based or non-schema based. It also takes an additional (optional) parameter that specifies how to delete it. This parameter is only relevant for schema-based resource metadata that needs to be deleted. For non-schema based metadata, this parameter is ignored.

Syntax

Can be used only for schema-based metadata:

DBMS_XDB.DELETERESOURCEMETADATA (
   abspath        IN  VARCHAR2, 
   metadata       IN  REF SYS.XMLTYPE,
   delete_option  IN  pls_integer := dbms_xdb.DELETE_RESOURCE_METADATA_CASCADE);
 

Can be used for schema-based or nonschema-based metadata:

DBMS_XDB.DELETERESOURCEMETADATA (
   abspath        IN VARCHAR2,
   metadatans     IN VARCHAR2,
   metadataname   IN VARCHAR2,
   delete_option  IN pls_integer := dbms_xdb.DELETE_RESOURCE_METADATA_CASCADE);

Parameters

Table 181-23 DELETERESOURCEMETADATA Procedure Parameters

Parameter Description

abspath

Absolute path of the resource

metadata

REF to the piece of metadata (schema based) to be deleted

mettadatans

Namespace of the metadata fragment to be removed

mettadataname

Local name of the metadata fragment to be removed

delete_option

Only applicable for schema-based metadata, this can be one of the following:

  • DELETE_RES_METADATA_CASCADE - deletes the corresponding row in the metadata table

  • DELETE_RES_METADATA_NOCASCADE - does not delete the row in the metadata table


DELETESCHEMALOCMAPPING Procedure

Note:

This procedure is deprecated in Release 12c. This functionality is replaced by a subprogram of the same name in the DBMS_XDB_CONFIG package - the DELETESCHEMALOCMAPPING Procedure.

This procedure deletes the schema location mapping for a specified schema URL from the XDB configuration.

Syntax

DBMS_XDB.DELETESCHEMALOCMAPPING(
     schemaURL    IN   VARCHAR2);

Parameters

Table 181-24 DELETESCHEMALOCMAPPING Procedure Parameters

Parameter Description

schemaURL

Schema URL


DELETESERVLET Procedure

Note:

This procedure is deprecated in Release 12c. This functionality is replaced by a subprogram of the same name in the DBMS_XDB_CONFIG package - the DELETESERVLET Procedure.

This procedure deletes a servlet from the XDB configuration.

Syntax

DBMS_XDB.DELETESERVLET(
     name        IN   VARCHAR2);

Parameters

Table 181-25 DELETESERVLET Procedure Parameters

Parameter Description

name

Servlet name


DELETESERVLETMAPPING Procedure

Note:

This procedure is deprecated in Release 12c. This functionality is replaced by a subprogram of the same name in the DBMS_XDB_CONFIG package - the DELETESERVLETMAPPING Procedure.

This procedure deletes the servlet mapping for a specified servlet name from the XDB configuration.

Syntax

DBMS_XDB.DELETESERVLETMAPPING(
     name      IN   VARCHAR2);

Parameters

Table 181-26 DELETESERVLETMAPPING Procedure Parameters

Parameter Description

name

Servlet name


DELETESERVLETSECROLE Procedure

Note:

This procedure is deprecated in Release 12c. This functionality is replaced by a subprogram of the same name in the DBMS_XDB_CONFIG package - the DELETESERVLETSECROLE Procedure.

This procedure deletes the specified role from a servlet in the XDB configuration.

Syntax

DBMS_XDB.DELETESERVLETSECROLE(
     servname    IN   VARCHAR2,     rolename    IN   VARCHAR2);

Parameters

Table 181-27 DELETESERVLETSECROLE Procedure Parameters

Parameter Description

servname

Servlet name

rolename

Name of the role to be deleted


DELETEXMLEXTENSION Procedure

Note:

This procedure is deprecated in Release 12c. This functionality is replaced by a subprogram of the same name in the DBMS_XDB_CONFIG package - the DELETEXMLEXTENSION Procedure.

This procedure deletes the specified XML extension from the XDB configuration.

Syntax

DBMS_XDB.DELETEXMLEXTENSION(
     extension    IN   VARCHAR2);

Parameters

Table 181-28 DELETEXMLEXTENSION Procedure Parameters

Parameter Description

extension

XML extension to be deleted


ENABLEDIGESTAUTHENTICATION Procedure

Note:

This procedure is deprecated in Release 12c. This functionality is replaced by a subprogram of the same name in the DBMS_XDB_CONFIG package - the ENABLEDIGESTAUTHENTICATION Procedure.

This procedure enabling digest authentication. It will list digest as the first authentication mechanism to be used by the XML DB HTTP server.

Syntax

DBMS_XDB.ENABLEDIGESTAUTHENTICATION;

EXISTSRESOURCE Function

Note:

This procedure is deprecated in Release 12c. This functionality is replaced by a subprogram of the same name in the DBMS_XDB_REPOS package - the EXISTSRESOURCE Function.

This function indicates if a resource is in the hierarchy. Matches resource by a string that represents its absolute path.

Syntax

DBMS_XDB.EXISTSRESOURCE(
   abspath    IN    VARCHAR2)
 RETURN BOOLEAN;

Parameters

Table 181-29 EXISTSRESOURCE Function Parameters

Parameter Description

abspath

Path name of the resource whose ACL document is required


Return Values

TRUE if the resource is found.

GETACLDOCUMENT Function

Note:

This procedure is deprecated in Release 12c. This functionality is replaced by a subprogram of the same name in the DBMS_XDB_REPOS package - the GETACLDOCUMENT Function.

This function retrieves ACL document that protects resource given its path name.

Syntax

DBMS_XDB.GETACLDOCUMENT(
   abspath  IN  VARCHAR2)
  RETURN sys.xmltype;

Parameters

Table 181-30 GETACLDOCUMENT Function Parameters

Parameter Description

abspath

Path name of the resource whose ACL document is required


Return Values

The XMLType for ACL document.

GETCONTENTBLOB Function

Note:

This procedure is deprecated in Release 12c. This functionality is replaced by a subprogram of the same name in the DBMS_XDB_REPOS package - the GETCONTENTBLOB Function.

This function retrieves the contents of a resource returned as a BLOB.

Syntax

DBMS_XDB.GETCONTENTBLOB(
     abspath    IN     VARCHAR2, 
     csid       OUT    PLS_INTEGER,
     locksrc    IN     BOOLEAN := FALSE) 
  RETURN BLOB;

Parameters

Table 181-31 GETCONTENTBLOB Function Parameters

Parameter Description

abspath

Absolute path of the resource

csid

If TRUE, lock and return the source LOB. If FALSE, return a temp LOB copy.

locksrc

Contents of the resource as a BLOB


Return Values

The contents of the resource as a BLOB.

GETCONTENTCLOB Function

Note:

This procedure is deprecated in Release 12c. This functionality is replaced by a subprogram of the same name in the DBMS_XDB_REPOS package - the GETCONTENTCLOB Function.

This function gets the contents of a resource returned as a CLOB.

Syntax

DBMS_XDB.GETCONTENTCLOB(
     abspath    IN     VARCHAR2,
  RETURN CLOB;

Parameters

Table 181-32 GETCONTENTCLOB Function Parameters

Parameter Description

abspath

Absolute path of the resource


Return Values

The contents of the resource as a CLOB.

GETCONTENTVARCHAR2 Function

Note:

This procedure is deprecated in Release 12c. This functionality is replaced by a subprogram of the same name in the DBMS_XDB_REPOS package - the GETCONTENTVARCHAR2 Function.

This function gets the contents of a resource returned as a string.

Syntax

DBMS_XDB.GETCONTENTVARCHAR2(
     abspath    IN     VARCHAR2,
  RETURN BLOB;

Parameters

Table 181-33 GETCONTENTVARCHAR2 Function Parameters

Parameter Description

abspath

Absolute path of the resource


Return Values

The contents of the resource as a string.

GETCONTENTXMLREF Function

Note:

This procedure is deprecated in Release 12c. This functionality is replaced by a subprogram of the same name in the DBMS_XDB_REPOS package - the GETCONTENTXMLREF Function.

This function retrieves the contents of a resource returned as a a REF to an XMLTYPE.

Syntax

DBMS_XDB.GETCONTENTXMLREF(
     abspath    IN     VARCHAR2,
  RETURN SYS.XMLTYPE;

Parameters

Table 181-34 GETCONTENTXMLREF Function Parameters

Parameter Description

abspath

Absolute path of the resource


Return Values

The contents of the resource as a REF to an XMLTYPE.

GETCONTENTXMLTYPE Function

Note:

This procedure is deprecated in Release 12c. This functionality is replaced by a subprogram of the same name in the DBMS_XDB_REPOS package - the GETCONTENTXMLTYPE Function.

This function retrieves the contents of a resource returned as an XMLTYPE.

Syntax

DBMS_XDB.GETCONTENTXMLTYPE(
     abspath    IN     VARCHAR2,
  RETURN SYS.XMLTYPE;

Parameters

Table 181-35 GETCONTENTXMLTYPE Function Parameters

Parameter Description

abspath

Absolute path of the resource


Return Values

The contents of the resource as an XMLTYPE.

GETFTPPORT Function

Note:

This procedure is deprecated in Release 12c. This functionality is replaced by a subprogram of the same name in the DBMS_XDB_CONFIG package - the GETFTPPORT Function.

This procedure gets the value of the current FTP port.

Syntax

DBMS_XDB.GETFTPPORT
 RETURN NUMBER;

GETHTTPPORT Function

Note:

This procedure is deprecated in Release 12c. This functionality is replaced by a subprogram of the same name in the DBMS_XDB_CONFIG package - the GETHTTPPORT Function.

This procedure gets the value of the current HTTP port.

Syntax

DBMS_XDB.GETHTTPPORT
 RETURN NUMBER;

GETHTTPREQUESTHEADER Function

Note:

This procedure is deprecated in Release 12c.

This function, if called during an HTTP request serviced by XDB, returns the values of the passed header. It is used by routines that implement custom authentication.

Syntax

DBMS_XDB.GETHTTPREQUESTHEADER(
    header_name    IN   VARCHAR2)
 RETURN VARCHAR2;

Parameters

Table 181-36 GETHTTPREQUESTHEADER Function Parameters

Parameter Description

header_name

Passed header


Return Values

Returns NULL in case the header is not present in the request, or for AUTHENTICATION, for security reasons.

GETLISTENERENDPOINT Procedure

Note:

This procedure is deprecated in Release 12c. This functionality is replaced by a subprogram of the same name in the DBMS_XDB_CONFIG package - the GETLISTENERENDPOINT Procedure.

This procedure retrieves the parameters of a listener end point corresponding to the XML DB HTTP server. The parameters of both HTTP and HTTP2 end points can be retrieved by invoking this procedure.

Syntax

DBMS_XDB.GETLISTENERENDPOINT (
   endpoint  IN   NUMBER, 
   host      OUT  VARCHAR2,    port      OUT  NUMBER, 
   protocol  OUT  NUMBER);

Parameters

Table 181-37 GETLISTENERENDPOINT Procedure Parameters

Parameter Description

endpoint

End point to be retrieved. Its value can be XDB_ENDPOINT_HTTP or XDB_ENDPOINT_HTTP2.

host

Interface on which the listener end point listens

port

Port on which the listener end point listens

protocol

Transport protocol accepted by the listener end point


GETLOCKTOKEN Procedure

Note:

This procedure is deprecated in Release 12c. This functionality is replaced by a subprogram of the same name in the DBMS_XDB_REPOS package - the GETLOCKTOKEN Procedure.

Given a path to a resource, this procedure returns that resource's lock token for the current user.

Syntax

DBMS_XDB.GETLOCKTOKEN(
   path         IN      VARCHAR2,
   locktoken    OUT     VARCHAR2);

Parameters

Table 181-38 GETLOCKTOKEN Procedure Parameters

Parameter Description

path

Path name to the resource

locktoken

Logged-in user's lock token for the resource


Usage Notes

The user must have READPROPERTIES privilege on the resource.

GETPRIVILEGES Function

Note:

This procedure is deprecated in Release 12c. This functionality is replaced by a subprogram of the same name in the DBMS_XDB_REPOS package - the GETPRIVILEGES Function.

This function gets all privileges granted to the current user on a specified resource.

Syntax

DBMS_XDB.GETPRIVILEGES(
   res_path    IN     VARCHAR2)
 RETURN sys.xmltype;

Parameters

Table 181-39 GETPRIVILEGES Function Parameters

Parameter Description

res_path

Absolute path in the hierarchy of the resource


Return Values

An XMLType instance of <privilege> element, which contains the list of all leaf privileges granted on this resource to the current user.

GETRESOID Function

Note:

This procedure is deprecated in Release 12c. This functionality is replaced by a subprogram of the same name in the DBMS_XDB_REPOS package - the GETRESOID Function.

Returns the object ID of the resource from its absolute path.

Syntax

DBMS_XDB.GETRESOID(
   abspath IN VARCHAR2)
RETURN RAW;

Parameters

Table 181-40 GETRESOID Function Parameters

Parameter Description

abspath_path

Absolute path of the resource


Return Values

NULL if the resource is not present.

GETXDB_TABLESPACE Function

Note:

This procedure is deprecated in Release 12c. This functionality is replaced by a subprogram of the same name in the DBMS_XDB_REPOS package - the GETXDB_TABLESPACE Function.

This function returns the current tablespace of the XDB (user).

Syntax

DBMS_XDB.GETXDB_TABLESPACE
 RETURN VARCHAR2;

HASBLOBCONTENT Function

Note:

This procedure is deprecated in Release 12c. This functionality is replaced by a subprogram of the same name in the DBMS_XDB_REPOS package - the HASBLOBCONTENT Function.

This function returns TRUE if the resource has BLOB content.

Syntax

DBMS_XDB.HASBLOBCONTENT 
     abspath    IN     VARCHAR2)
 RETURN BOOLEAN;

Parameters

Table 181-41 HASBLOBCONTENT Function Parameters

Parameter Description

abspath_path

Absolute path of the resource


Return Values

TRUE if the resource has BOB content.

HASCHARCONTENT Function

Note:

This procedure is deprecated in Release 12c. This functionality is replaced by a subprogram of the same name in the DBMS_XDB_REPOS package - the HASCHARCONTENT Function.

This function returns TRUE if the resource has character content.

Syntax

DBMS_XDB.HASCHARCONTENT 
     abspath    IN     VARCHAR2)
 RETURN BOOLEAN;

Parameters

Table 181-42 HASCHARCONTENT Function Parameters

Parameter Description

abspath_path

Absolute path of the resource


Return Values

TRUE if the resource has character content.

HASXMLCONTENT Function

Note:

This procedure is deprecated in Release 12c. This functionality is replaced by a subprogram of the same name in the DBMS_XDB_REPOS package - the HASXMLCONTENT Function.

This function returns TRUE if the resource has XML content.

Syntax

DBMS_XDB.HASXMLCONTENT 
     abspath    IN     VARCHAR2)
 RETURN BOOLEAN;

Parameters

Table 181-43 HASXMLCONTENT Function Parameters

Parameter Description

abspath_path

Absolute path of the resource


Return Values

TRUE if the resource has XML content.

HASXMLREFERENCE Function

Note:

This procedure is deprecated in Release 12c. This functionality is replaced by a subprogram of the same name in the DBMS_XDB_REPOS package - the HASXMLREFERENCE Function.

This function returns TRUE if the resource has a REF to XML content.

Syntax

DBMS_XDB.HASXMLREFERENCE 
     abspath    IN     VARCHAR2)
 RETURN BOOLEAN;

Parameters

Table 181-44 HASXMLREFERENCE Function Parameters

Parameter Description

abspath_path

Absolute path of the resource


Return Values

TRUE resource has a REF to XML content.

ISFOLDER Function

Note:

This procedure is deprecated in Release 12c. This functionality is replaced by a subprogram of the same name in the DBMS_XDB_REPOS package - the ISFOLDER Function.

This function returns TRUE if the resource is a folder or container.

Syntax

DBMS_XDB.ISFOLDER 
     abspath    IN     VARCHAR2)
 RETURN BOOLEAN;

Parameters

Table 181-45 DBMS_XDB.ISFOLDER Function Parameters

Parameter Description

abspath_path

Absolute path of the resource


Return Values

TRUE if the resource is a folder or container.

LINK Procedures

Note:

This procedure is deprecated in Release 12c. This functionality is replaced by a subprogram of the same name in the DBMS_XDB_REPOS package - the LINK Procedures.

This procedure creates from a specified folder to a specified resource.

Syntax

DBMS_XDB.LINK(
   srcpath      IN   VARCHAR2,
   linkfolder   IN   VARCHAR2,
   linkname     IN   VARCHAR2);
DBMS_XDB.LINK(
   srcpath      IN   VARCHAR2,
   linkfolder   IN   VARCHAR2,
   linkname     IN   VARCHAR2,
   linktype     IN   PLS_INTEGER := DBMS_XDB.LINK_TYPE_HARD);

Parameters

Table 181-46 LINK Procedure Parameters

Parameter Description

srcpath

Path name of the resource to which a link is created

linkfolder

Folder in which the new link is placed

linkname

Name of the new link

linktype

Type of link to be created:

  • DBMS_XDB.LINK_TYPE_HARD (default)

  • DBMS_XDB.LINK_TYPE_WEAK

  • DBMS_XDB.LINK_TYPE_SYMBOLIC


LOCKRESOURCE Function

Note:

This procedure is deprecated in Release 12c. This functionality is replaced by a subprogram of the same name in the DBMS_XDB_REPOS package - the LOCKRESOURCE Function.

Given a path to a resource, this function gets a WebDAV-style lock on that resource.

Syntax

DBMS_XDB.LOCKRESOURCE(
   path      IN  VARCHAR2,
   depthzero IN  BOOLEAN,
   shared    IN  boolean)
RETURN BOOLEAN;

Parameters

Table 181-47 LOCKRESOURCE Function Parameters

Parameter Description

path

Path name of the resource to lock.

depthzero

Currently not supported

shared

Passing TRUE obtains a shared write lock


Return Values

TRUE if successful.

Usage Notes

The user must have UPDATE privileges on the resource.

PROCESSLINKS Procedure

Note:

This procedure is deprecated in Release 12c. This functionality is replaced by a subprogram of the same name in the DBMS_XDB_REPOS package - the PROCESSLINKS Procedure.

This procedure processes document links in the specified resource.

Syntax

DBMS_XDB.PURGERESOURCEMETADATA( 
 abspath  IN  VARCHAR2,
 recurse  IN  BOOLEAN := FALSE);

Parameters

Table 181-48 PROCESSLINKS Procedure Parameters

Parameter Description

abspath

Absolute path of the resource. If the path is a folder, use the recurse flag.

recurse

Used only if abspath specifies a folder. If TRUE, process links of all resources in the folder hierarchy rooted at the specified resource. If FALSE, process links of all documents in this folder only.


PURGERESOURCEMETADATA Procedure

Note:

This procedure is deprecated in Release 12c. This functionality is replaced by a subprogram of the same name in the DBMS_XDB_REPOS package - the PURGERESOURCEMETADATA Procedure.

This procedure deletes all user metadata from a resource. Schema-based metadata is removed in cascade mode, rows being deleted from the corresponding metadata tables.

Syntax

DBMS_XDB.PURGERESOURCEMETADATA(  
 abspath  IN  VARCHAR2);

Parameters

Table 181-49 PURGERESOURCEMETADATA Procedure Parameters

Parameter Description

abspath

Absolute path of the resource


RENAMERESOURCE Procedure

Note:

This procedure is deprecated in Release 12c. This functionality is replaced by a subprogram of the same name in the DBMS_XDB_REPOS package - the RENAMERESOURCE Procedure.

This procedure renames the XDB resource.

Syntax

DBMS_XDB.RENAMERESOURCE(
   srcpath    IN  VARCHAR2,
   destfolder IN  CARCHAR2,
   newname    IN  VARCHAR2);

Parameters

Table 181-50 RENAMERESOURCE Procedure Parameters

Parameter Description

srcpath

Absolute path in the Hierarchy for the source resource destination folder

destfolder

Absolute path in the Hierarchy for the destination folder

newname

Name of the child in the destination folder


SETACL Procedure

Note:

This procedure is deprecated in Release 12c. This functionality is replaced by a subprogram of the same name in the DBMS_XDB_REPOS package - the SETACL Procedure.

This procedure sets the ACL on a specified resource to be the ACL specified by path.

Syntax

DBMS_XDB.SETACL(
   res_path   IN  VARCHAR2,
   acl_path   IN  VARCHAR2);

Parameters

Table 181-51 SETACL Procedure Parameters

Parameter Description

res_path

Absolute path in the Hierarchy for resource

acl_path

Absolute path in the Hierarchy for ACL


Usage Notes

The user must have <write-acl> privileges on the resource.

SETFTPPORT Procedure

Note:

This procedure is deprecated in Release 12c. This functionality is replaced by a subprogram of the same name in the DBMS_XDB_CONFIG package - the SETFTPPORT Procedure.

This procedure sets the FTP port to a new value.

Syntax

DBMS_XDB.SETFTPPORT(
   new_port  IN  NUMBER);

Parameters

Table 181-52 SETFTPPORT Procedure Parameters

Parameter Description

new_port

Value to which the FTP port is set


SETHTTPPORT Procedure

Note:

This procedure is deprecated in Release 12c. This functionality is replaced by a subprogram of the same name in the DBMS_XDB_CONFIG package - the SETHTTPPORT Procedure.

This procedure sets the HTTP port to a new value.

Syntax

DBMS_XDB.SETHTTPPORT(
   new_port  IN  NUMBER);

Parameters

Table 181-53 SETHTTPPORT Procedure Parameters

Parameter Description

new_port

Value to which the HTTP port is set


SETLISTENERENDPOINT Procedure

Note:

This procedure is deprecated in Release 12c. This functionality is replaced by a subprogram of the same name in the DBMS_XDB_CONFIG package - the SETLISTENERENDPOINT Procedure.

This procedure sets the parameters of a listener end point corresponding to the XML DB HTTP server. Both HTTP and HTTP2 end points can be set by invoking this procedure.

Syntax

DBMS_XDB.SETLISTENERENDPOINT (
   endpoint  IN  NUMBER, 
   host      IN  VARCHAR2,    port      IN  NUMBER, 
   protocol  IN  NUMBER);

Parameters

Table 181-54 SETLISTENERENDPOINT Procedure Parameters

Parameter Description

endpoint

End point to be set. Its value can be XDB_ENDPOINT_HTTP or XDB_ENDPOINT_HTTP2.

host

Interface on which the listener end point is to listen. Its value can be 'LOCALHOST,' NULL, or a hostname. If its value is 'LOCALHOST' the listener end point is permitted to only listen on the localhost interface. If its value is NULL or hostname, the listener end point is permitted to listen on both localhost and non-localhost interfaces.

port

Port on which the listener end point is to listen

protocol

Transport protocol that the listener end point is to accept. Its value can be XDB_PROTOCOL_TCP or XDB_PROTOCOL_TCPS


SETLISTENERLOCALACCESS Procedure

Note:

This procedure is deprecated in Release 12c. This functionality is replaced by a subprogram of the same name in the DBMS_XDB_CONFIG package - the SETLISTENERLOCALACCESS Procedure.

This procedure restricts all listener end points of the XML DB HTTP server to listen either only on the localhost interface (when l_access is set to TRUE) or to listen on both localhost and non-localhost interfaces (when l_access is set to FALSE).

Syntax

DBMS_XDB.SETLISTENERLOCALACCESS (
   l_access   BOOLEAN);

Parameters

Table 181-55 SETLISTENERLOCALACCESS Procedure Parameters

Parameter Description

l_access.

TRUE or FALSE.


SPLITPATH Procedure

Note:

This procedure is deprecated in Release 12c. This functionality is replaced by a subprogram of the same name in the DBMS_XDB_REPOS package - the SPLITPATH Procedure.

This procedure splits the path into a parentpath and childpath.

Syntax

DBMS_XDB.SPLITPATH(
      abspath     IN  VARCHAR2,
      parentpath  OUT VARCHAR2,
     childpath    OUT VARCHAR2);

Parameters

Table 181-56 SPLITPATH Procedure Parameters

Parameter Description

abspath

Absolute path to be split

parentpath

Parentpath

childpath

Childpath


TOUCHRESOURCE Procedure

Note:

This procedure is deprecated in Release 12c. This functionality is replaced by a subprogram of the same name in the DBMS_XDB_REPOS package - the TOUCHRESOURCE Procedure.

This procedure changes the modification time of the resource to the current time.

Syntax

DBMS_XDB.TOUCHRESOURCE 
     abspath    IN     VARCHAR2);

Parameters

Table 181-57 DBMS_XDB.TOUCHRESOURCE Procedure Parameters

Parameter Description

abspath_path

Absolute path of the resource


UNLOCKRESOURCE Function

Note:

This procedure is deprecated in Release 12c. This functionality is replaced by a subprogram of the same name in the DBMS_XDB_REPOS package - the UNLOCKRESOURCE Function.

This function unlocks the resource given a lock token and a path to the resource.

Syntax

DBMS_XDB.UNLOCKRESOURCE(
   path     IN  VARCHAR2,
   deltoken IN  VARCHAR2)
 RETURN BOOLEAN;

Parameters

Table 181-58 UNLOCKRESOURCE Function Parameters

Parameter Description

path

Path name to the resource

deltoken

Lock token to be removed


Return Values

TRUE if operation successful.

Usage Notes

The user must have UPDATE privileges on the resource.

UPDATERESOURCEMETADATA Procedures

Note:

This procedure is deprecated in Release 12c. This functionality is replaced by a subprogram of the same name in the DBMS_XDB_REPOS package - the UPDATERESOURCEMETADATA Procedures.

This procedure updates metadata for a resource. The procedure takes in a resource identified by absolute path and the metadata in it to replace identified by its REF. It replaces that piece of metadata with user-defined metadata which is either in the form of a REF to XMLTYPE or an XMLTYPE.

Syntax

Can be used to update schema-based metadata only. The new metadata must be schema-based:

DBMS_XDB.UPDATERESOURCEMETADATA(
   abspath  IN VARCHAR2,
   oldmetadata    IN   REF SYS.XMLTYPE,
   newmetadata    IN   REF SYS.XMLTYPE)
 

Can be used to update schema-based metadata only. The new metadata must be schema-based or nonschema-based:

DBMS_XDB.UPDATERESOURCEMETADATA(
   abspath        IN   VARCHAR2,
   oldmetadata    IN   REF SYS.XMLTYPE,
   newmetadata    IN   XMLTYPE);
 

Can be used for both schema-based and nonschema-based metadata:

DBMS_XDB.UPDATERESOURCEMETADATA(
   abspath        IN   VARCHAR2,
   oldns          IN   VARCHAR2,
   oldname IN VARCHAR,
   newmetadata IN XMLTYPE);
 

Can be used for both schema-based or nonschema-based metadata. New metadata must be schema-based:

DBMS_XDB.UPDATERESOURCEMETADATA(
   abspath       IN   VARCHAR2,
   oldns         IN   VARCHAR2,
   oldname       IN   VARCHAR,
   newmetadata   IN   REF SYS.XMLTYPE);

Parameters

Table 181-59 UPDATERESOURCEMETADATA Procedure Parameters

Parameter Description

abspath

Absolute path of the resource

oldmetadata

REF to the old of metadata

newmetadata

REF to the new, replacement metadata (can be either schema-based or nonschema-based depending on the overload)

oldns

Namespace identifying old metadata

oldname

Local name identifying old metadata


Usage Notes

In the case of REF, it stores the REF in the resource and the metadata is stored in a separate table. Uniqueness of REFs is enforced. In the case where the XMLTYPE is passed in, data is parsed to determine if it is schema-based or not and is stored accordingly.