Skip Headers
Oracle® Database PL/SQL Packages and Types Reference
11g Release 2 (11.2)

Part Number E25788-04
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub
ARPLS230

166 DBMS_XDBRESOURCE

The DBMS_XDBRESOURCE package provides the interface to operate on the resource's metadata and contents.

See Also:

Oracle XML DB Developer's Guide for examples of "Using DBMS_XDBRESOURCE"

This chapter contains the following topics:

ARPLS69314

Using DBMS_XDBRESOURCE

ARPLS69315

Overview

The DBMS_XDBRESOURCE package provides routines to get and set the resource's metadata and contents. To take advantage of the DOM traversal facility, provided in DBMS_XMLDOM package, an XDBResource instance could be converted to a DOMDocument type by using DBMS_XDBRESOURCE.MAKEDOCUMENT routine.

ARPLS73524

Security Model

Owned by XDB, the DBMS_XDBRESOURCE 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.

ARPLS69316

Summary of DBMS_XDBRESOURCE Subprograms

ARPLS69317Table 166-1 DBMS_XDBRESOURCE Package Subprograms

Subprogram Description

FREERESOURCE Procedure

Frees any memory associated with an XDBResource

GETACL Function

Given an XDBResource, returns its ACL as string

GETACLDOCFROMRES Function

Returns the ACL Document for the given resource as XMLType

GETAUTHOR Function

Given an XDBResource, returns its author

GETCHARACTERSET Function

Given an XDBResource, returns its character set

GETCOMMENT Function

Given an XDBResource, returns its comment

GETCONTENTBLOB Function

Returns the contents of the resource as a BLOB

GETCONTENTCLOB Function

Returns the contents of the resource as a CLOB

GETCONTENTREF Function

Returns the contents of the resource as an XMLTypeRef

GETCONTENTTYPE Function

Given an XDBResource, returns its content-type

GETCONTENTXML Function

Returns the contents of the resource as XML

GETCONTENTVARCHAR2 Function

Returns the contents of the resource as a string

GETCREATIONDATE Function

Given an XDBResource, returns its creation date

GETCREATOR Function

Given an XDBResource, returns its creator

GETCUSTOMMETADATA Function

Returns the requested custom metadata given the xpath and namespace to the metadata

GETDISPLAYNAME Function

Given an XDBResource, returns its display name

GETLANGUAGE Function

Given an XDBResource, returns its language

GETLASTMODIFIER Function

Given an XDBResource, returns its last modifier

GETMODIFICATIONDATE Function

Given an XDBResource, returns its modification date

GETOWNER Function

Given an XDBResource, returns its owner.

GETREFCOUNT Function

Given an XDBResource, returns its reference count

GETVERSIONID Function

Given an XDBResource, returns its version ID.

HASACLCHANGED Function

Returns TRUE if the ACL of the given resource has changed, FALSE otherwise

HASAUTHORCHANGED Function

Returns TRUE if the ACL of the given resource has changed FALSE otherwise

HASCHANGED Function

Returns TRUE if the element or attribute represented by the given XPath has changed, FALSE otherwise

HASCHARACTERSETCHANGED Function

Returns TRUE if the character set of the given resource has changed, FALSE otherwise

HASCOMMENTCHANGED Function

Returns TRUE if the comment of the given resource has changed, FALSE otherwise

HASCONTENTCHANGED Function

Returns TRUE if the contents of the given resource has changed, FALSE otherwise

HASCONTENTTYPECHANGED Function

Returns TRUE if the content-type of the given resource has changed, FALSE otherwise

HASCREATIONDATECHANGED Function

Returns TRUE if the creation date of the given resource has changed, FALSE otherwise

HASCREATORCHANGED Function

Returns TRUE if the creator of the given resource has changed, FALSE otherwise

HASCUSTOMMETADATACHANGED Function

Returns TRUE if custom-metadata for this XPath has changed, FALSE otherwise

HASDISPLAYNAMECHANGED Function

Returns TRUE if the display name of the given resource has changed, FALSE otherwise

HASLANGUAGECHANGED Function

Returns TRUE if the language of the given resource has changed, FALSE otherwise

HASLASTMODIFIERCHANGED Function

Returns TRUE if the last modifier of the given resource has changed, FALSE otherwise

HASMODIFICATIONDATECHANGED Function

Returns TRUE if the modification date of the given resource has changed, FALSE otherwise

HASOWNERCHANGED Function

Returns TRUE if the owner of the given resource has changed, FALSE otherwise

HASREFCOUNTCHANGED Function

Returns TRUE if the reference count of the given resource has changed, FALSE otherwise

HASVERSIONIDCHANGED Function

Returns TRUE if the version ID of the given resource has changed, FALSE otherwise

ISFOLDER Function

Returns TRUE if the given resource is a folder, FALSE otherwise

ISNULL Function

Returns TRUE if input resource is NULL, FALSE otherwise

MAKEDOCUMENT Function

Converts the XDBResource to a DOMDocument which can be operated on using the XMLDOM interface

SAVE Procedure

Updates the resource with any modifications

SETACL Procedure

Sets the ACL of the given XDBResource to the path specified

SETAUTHOR Procedure

Sets the author of the given XDBResource to the specified string

SETCHARACTERSET Procedure

Sets the character set of the given XDBResource to a specified character set

SETCOMMENT Procedure

Sets a comment associated with the given XDBResource

SETCONTENT Procedures

Replaces the contents of the given resource with the given CLOB

SETCONTENTTYPE Procedure

Sets the content-type of the given XDBResource

SETCUSTOMMETADATA Procedure

Sets the custom metadata specified by the XPath and namespace to new data

SETDISPLAYNAME Procedure

Sets the display name of the given XDBResource

SETLANGUAGE Procedure

Sets the language of the given XDBResource

SETOWNER Procedure

Sets the owner of the given XDBResource


ARPLS69318

FREERESOURCE Procedure

This procedure frees any memory associated with an XDBResource.

Syntax

DBMS_XDBRESEROUCE.FREERESOURCE (
   res   IN    XDBResource) 
 RETURN VARCHAR2;

Parameters

ARPLS69319Table 166-2 FREERESOURCE Procedure Parameters

Parameter Description

res

XDBResource to free


ARPLS69320

GETACL Function

Given an XDBResource, this function returns its ACL as string.

Syntax

DBMS_XDBRESEROUCE.GETACL (
   res   IN    XDBResource) 
 RETURN VARCHAR2;

Parameters

ARPLS69321Table 166-3 GETACL Function Parameters

Parameter Description

res

XDBResource


ARPLS69322

GETACLDOCFROMRES Function

This function returns the ACL Document for the given resource as XMLType.

Syntax

DBMS_XDBRESEROUCE.GETACLDOCFROMRES (
   res   IN    XDBResource) 
 RETURN SYS.XMLTYPE;

Parameters

ARPLS69323Table 166-4 GETACL Function Parameters

Parameter Description

res

XDBResource


ARPLS69324

GETAUTHOR Function

Given an XDBResource, this function returns its author.

Syntax

DBMS_XDBRESEROUCE.GETAUTHOR (
   res   IN    XDBResource) 
 RETURN VARCHAR2;

Parameters

ARPLS69325Table 166-5 GETAUTHOR Function Parameters

Parameter Description

res

XDBResource


ARPLS69326

GETCHARACTERSET Function

Given an XDBResource, this function returns its characterset.

Syntax

DBMS_XDBRESEROUCE.GETCHARACTERSET (
   res   IN    XDBResource) 
 RETURN VARCHAR2;

Parameters

ARPLS69327Table 166-6 GETCHARACTERSET Function Parameters

Parameter Description

res

XDBResource


ARPLS69328

GETCOMMENT Function

Given an XDBResource, this function returns its comment.

Syntax

DBMS_XDBRESEROUCE.GETCOMMENT (
   res   IN    XDBResource) 
 RETURN VARCHAR2;

Parameters

ARPLS69329Table 166-7 GETCOMMENT Function Parameters

Parameter Description

res

XDBResource


ARPLS69330

GETCONTENTBLOB Function

This function returns the contents of the resource as a BLOB.

Syntax

DBMS_XDBRESEROUCE.GETCONTENTBLOB (
   res    IN     XDBResource,
   csid   OUT    PLS_INTEGER) 
 RETURN BLOB;

Parameters

ARPLS69331Table 166-8 GETCONTENTBLOB Function Parameters

Parameter Description

res

XDBResource

csid

Character set ID of the BLOB returned


ARPLS69332

GETCONTENTCLOB Function

This function returns the contents of the resource as a CLOB.

Syntax

DBMS_XDBRESEROUCE.GETCONTENTCLOB (
   res   IN    XDBResource) 
 RETURN CLOB;

Parameters

ARPLS69333Table 166-9 GETCONTENTCLOB Function Parameters

Parameter Description

res

XDBResource


ARPLS69334

GETCONTENTREF Function

This function returns the contents of the resource as an XMLTypeRef.

Syntax

DBMS_XDBRESEROUCE.GETCONTENTREF (
   res   IN    XDBResource) 
 RETURN VARCHAR2;

Parameters

ARPLS69335Table 166-10 GETCONTENTREF Function Parameters

Parameter Description

res

XDBResource


ARPLS69336

GETCONTENTTYPE Function

Given an XDBResource, this function returns its content-type.

Syntax

DBMS_XDBRESEROUCE.GETCONTENTTYPE (
   res   IN    XDBResource) 
 RETURN VARCHAR2;

Parameters

ARPLS69337Table 166-11 GETCONTENTTYPE Function Parameters

Parameter Description

res

XDBResource


ARPLS69338

GETCONTENTXML Function

This function returns the contents of the resource as an XMLTypeRef.

Syntax

DBMS_XDBRESEROUCE.GETCONTENTXML (
   res   IN    XDBResource) 
 RETURN XMLType;

Parameters

ARPLS69339Table 166-12 GETCONTENTXML Function Parameters

Parameter Description

res

XDBResource


ARPLS69340

GETCONTENTVARCHAR2 Function

This function returns the contents of the resource as a string.

Syntax

DBMS_XDBRESEROUCE.GETCONTENTVARCHAR2 (
   res   IN    XDBResource) 
 RETURN VARCHAR2;

Parameters

ARPLS69341Table 166-13 GETCONTENTVARCHAR2 Function Parameters

Parameter Description

res

XDBResource


ARPLS69342

GETCREATIONDATE Function

Given an XDBResource, this function returns its creation date.

Syntax

DBMS_XDBRESEROUCE.GETCREATIONDATE (
   res   IN    XDBResource) 
 RETURN TIMESTAMP;

Parameters

ARPLS69343Table 166-14 GETCREATIONDATE Function Parameters

Parameter Description

res

XDBResource


ARPLS69344

GETCREATOR Function

Given an XDBResource, this function returns its creator.

Syntax

DBMS_XDBRESEROUCE.GETCREATOR (
   res   IN    XDBResource) 
 RETURN VARCHAR2;

Parameters

ARPLS69345Table 166-15 GETCREATOR Function Parameters

Parameter Description

res

XDBResource


ARPLS69346

GETCUSTOMMETADATA Function

This function returns the requested custom metadata given the xpath and namespace to the metadata.

Syntax

DBMS_XDBRESEROUCE.GETCUSTOMMETADATA (
   res        IN    XDBResource, 
   xpath      IN    VARCHAR2,    namespace  IN    VARCHAR2)
 RETURN XMLType;

Parameters

ARPLS69347Table 166-16 GETCUSTOMMETADATA Function Parameters

Parameter Description

res

XDBResource

xpath

XPath for custom metadata

namespace

Namespace


Usage Notes

The first component of the XPath expression must be "Resource".

ARPLS69348

GETDISPLAYNAME Function

Given an XDBResource, this function returns its display name.

Syntax

DBMS_XDBRESEROUCE.GETDISPLAYNAME (
   res   IN    XDBResource) 
 RETURN VARCHAR2;

Parameters

ARPLS69349Table 166-17 GETDISPLAYNAME Function Parameters

Parameter Description

res

XDBResource


ARPLS69350

GETLANGUAGE Function

Given an XDBResource, this function returns its language.

Syntax

DBMS_XDBRESEROUCE.GETLANGUAGE (
   res   IN    XDBResource) 
 RETURN VARCHAR2;

Parameters

ARPLS69351Table 166-18 GETLANGUAGE Function Parameters

Parameter Description

res

XDBResource


ARPLS69352

GETLASTMODIFIER Function

Given an XDBResource, this function returns its last modifier.

Syntax

DBMS_XDBRESEROUCE.GETLASTMODIFIER (
   res   IN    XDBResource) 
 RETURN VARCHAR2;

Parameters

ARPLS69353Table 166-19 GETLASTMODIFIER Function Parameters

Parameter Description

res

XDBResource


ARPLS69354

GETMODIFICATIONDATE Function

Given an XDBResource, this function returns its modification date.

Syntax

DBMS_XDBRESEROUCE.GETMODIFICATIONDATE (
   res   IN    XDBResource) 
 RETURN TIMESTAMP;

Parameters

ARPLS69355Table 166-20 GETMODIFICATIONDATE Function Parameters

Parameter Description

res

XDBResource


ARPLS69356

GETOWNER Function

Given an XDBResource, this function returns its owner.

Syntax

DBMS_XDBRESEROUCE.GETOWNER (
   res   IN    XDBResource) 
 RETURN VARCHAR2;

Parameters

ARPLS69357Table 166-21 GETOWNER Function Parameters

Parameter Description

res

XDBResource


ARPLS69358

GETREFCOUNT Function

Given an XDBResource, this function returns its reference count.

Syntax

DBMS_XDBRESEROUCE.GETREFCOUNT (
   res   IN    XDBResource) 
 RETURN PLS_INTEGER;

Parameters

ARPLS69359Table 166-22 GETREFCOUNT Function Parameters

Parameter Description

res

XDBResource


ARPLS69360

GETVERSIONID Function

Given an XDBResource, this function returns its version ID.

Syntax

DBMS_XDBRESEROUCE.GETVERSIONID (
   res   IN    XDBResource) 
 RETURN PLS_INTEGER;

Parameters

ARPLS69361Table 166-23 GETVERSIONID Function Parameters

Parameter Description

res

XDBResource


ARPLS69362

HASACLCHANGED Function

This function returns TRUE if the ACL of the given resource has changed, FALSE otherwise.

Syntax

DBMS_XDBRESEROUCE.HASACLCHANGED (
   res   IN    XDBResource) 
 RETURN BOOLEAN;

Parameters

ARPLS69363Table 166-24 GETACL Function Parameters

Parameter Description

res

XDBResource


ARPLS69364

HASAUTHORCHANGED Function

This function returns TRUE if the author of the given resource has changed, FALSE otherwise.

Syntax

DBMS_XDBRESEROUCE.HASAUTHORCHANGED (
   res   IN    XDBResource) 
 RETURN BOOLEAN;

Parameters

ARPLS69365Table 166-25 HASAUTHORCHANGED Function Parameters

Parameter Description

res

XDBResource


ARPLS69366

HASCHANGED Function

Given an XPath, this function determines whether the element or attribute represented by the XPath has changed.

Syntax

DBMS_XDBRESEROUCE.HASCHANGED (
   res         IN    XDBResource, 
   xpath       IN    VARCHAR2,
   namespace   IN    VARCHAR2) 
 RETURN BOOLEAN;

Parameters

ARPLS69367Table 166-26 HASCHANGED Function Parameters

Parameter Description

res

XDBResource

xpath

XPath to check

bnamespace

Namespace to use


ARPLS69368

HASCHARACTERSETCHANGED Function

This function returns TRUE if the character set of the given resource has changed, FALSE otherwise.

Syntax

DBMS_XDBRESEROUCE.HASCHARACTERSETCHANGED (
   res   IN    XDBResource) 
 RETURN BOOLEAN;

Parameters

ARPLS69369Table 166-27 HASCHARACTERSETCHANGED Function Parameters

Parameter Description

res

XDBResource


ARPLS69370

HASCOMMENTCHANGED Function

This function returns TRUE if the comment of the given resource has changed, FALSE otherwise.

Syntax

DBMS_XDBRESEROUCE.HASCOMMENTCHANGED (
   res   IN    XDBResource) 
 RETURN BOOLEAN;

Parameters

ARPLS69371Table 166-28 HASCOMMENTCHANGED Function Parameters

Parameter Description

res

XDBResource


ARPLS69372

HASCONTENTCHANGED Function

This function returns TRUE if the contents of the given resource has changed, FALSE otherwise.

Syntax

DBMS_XDBRESEROUCE.HASCONTENTCHANGED (
   res   IN    XDBResource) 
 RETURN BOOLEAN;

Parameters

ARPLS69373Table 166-29 HASCONTENTCHANGED Function Parameters

Parameter Description

res

XDBResource


ARPLS69374

HASCONTENTTYPECHANGED Function

This function returns TRUE if the content-type of the given resource has changed, FALSE otherwise

Syntax

DBMS_XDBRESEROUCE.HASCONTENTTYPECHANGED (
   res   IN    XDBResource) 
 RETURN BOOLEAN;

Parameters

ARPLS69375Table 166-30 HASCONTENTTYPECHANGED Function Parameters

Parameter Description

res

XDBResource


ARPLS69376

HASCREATIONDATECHANGED Function

This function returns TRUE if the creation date of the given resource has changed, FALSE otherwise

Syntax

DBMS_XDBRESEROUCE.HASCREATIONDATECHANGED (
   res   IN    XDBResource) 
 RETURN BOOLEAN;

Parameters

ARPLS69377Table 166-31 HASCREATIONDATECHANGED Function Parameters

Parameter Description

res

XDBResource


ARPLS69378

HASCREATORCHANGED Function

This function returns TRUE if the creator of the given resource has changed, FALSE otherwise

Syntax

DBMS_XDBRESEROUCE.HASCREATORCHANGED (
   res   IN    XDBResource) 
 RETURN BOOLEAN;

Parameters

ARPLS69379Table 166-32 HASCREATORCHANGED Function Parameters

Parameter Description

res

XDBResource


ARPLS69380

HASCUSTOMMETADATACHANGED Function

This function checks whether the custom-metadata for a given resource has changed.

Syntax

DBMS_XDBRESEROUCE.HASCUSTOMMETADATACHANGED (
   res   IN    XDBResource) 
 RETURN BOOLEAN;

Parameters

ARPLS69381Table 166-33 HASCUSTOMMETADATACHANGED Function Parameters

Parameter Description

res

XDBResource


ARPLS69382

HASDISPLAYNAMECHANGED Function

This function returns TRUE if the display name of the given resource has changed, FALSE otherwise

Syntax

DBMS_XDBRESEROUCE.HASDISPLAYNAMECHANGED (
   res   IN    XDBResource) 
 RETURN BOOLEAN;

Parameters

ARPLS69383Table 166-34 HASDISPLAYNAMECHANGED Function Parameters

Parameter Description

res

XDBResource


ARPLS69384

HASLANGUAGECHANGED Function

This function returns TRUE if the language of the given resource has changed, FALSE otherwise

Syntax

DBMS_XDBRESEROUCE.HASLANGUAGECHANGED (
   res   IN    XDBResource) 
 RETURN BOOLEAN;

Parameters

ARPLS69385Table 166-35 HASLANGUAGECHANGED Function Parameters

Parameter Description

res

XDBResource


ARPLS69386

HASLASTMODIFIERCHANGED Function

This function returns TRUE if the last modifier of the given resource has changed, FALSE otherwise

Syntax

DBMS_XDBRESEROUCE.HASLASTMODIFIERCHANGED (
   res   IN    XDBResource) 
 RETURN BOOLEAN;

Parameters

ARPLS69387Table 166-36 HASLASTMODIFIERCHANGED Function Parameters

Parameter Description

res

XDBResource


ARPLS69388

HASMODIFICATIONDATECHANGED Function

This function returns TRUE if the modification date of the given resource has changed, FALSE otherwise

Syntax

DBMS_XDBRESEROUCE.HASMODIFICATIONDATECHANGED (
   res   IN    XDBResource) 
 RETURN BOOLEAN;

Parameters

ARPLS69389Table 166-37 HASMODIFICATIONDATECHANGED Function Parameters

Parameter Description

res

XDBResource


ARPLS69390

HASOWNERCHANGED Function

This function returns TRUE if the owner of the given resource has changed, FALSE otherwise.

Syntax

DBMS_XDBRESEROUCE.HASOWNERCHANGED (
   res   IN    XDBResource) 
 RETURN BOOLEAN;

Parameters

ARPLS69391Table 166-38 HASOWNERCHANGED Function Parameters

Parameter Description

res

XDBResource


ARPLS69392

HASREFCOUNTCHANGED Function

This function returns TRUE if the reference count of the given resource has changed, FALSE otherwise.

Syntax

DBMS_XDBRESEROUCE.HASREFCOUNTCHANGED (
   res   IN    XDBResource) 
 RETURN BOOLEAN;

Parameters

ARPLS69393Table 166-39 HASREFCOUNTCHANGED Function Parameters

Parameter Description

res

XDBResource


ARPLS69394

HASVERSIONIDCHANGED Function

This function returns TRUE if the version ID of the given resource has changed, FALSE otherwise.

Syntax

DBMS_XDBRESEROUCE.HASVERSIONIDCHANGED (
   res   IN    XDBResource) 
 RETURN BOOLEAN;

Parameters

ARPLS69395Table 166-40 HASVERSIONIDCHANGED Function Parameters

Parameter Description

res

XDBResource


ARPLS69396

ISFOLDER Function

This function returns TRUE if the given resource is a folder, FALSE otherwise.

Syntax

DBMS_XDBRESEROUCE.ISFOLDER (
   res   IN    XDBResource) 
 RETURN BOOLEAN;

Parameters

ARPLS69397Table 166-41 ISFOLDER Function Parameters

Parameter Description

res

XDBResource


ARPLS69398

ISNULL Function

This function returns TRUE if input resource is NULL.

Syntax

DBMS_XDBRESEROUCE.ISNULL (
   res   IN    XDBResource) 
 RETURN BOOLEAN;

Parameters

ARPLS69399Table 166-42 ISNULL Function Parameters

Parameter Description

res

Input resource


ARPLS69400

MAKEDOCUMENT Function

This function converts the XDBResource to a DOMDocument which can be operated on using the XMLDOM interface.

See Also:

The DBMS_XMLDOM package

Syntax

DBMS_XDBRESEROUCE.MAKEDOCUMENT (
   res   IN    XDBResource) 
 RETURN DBMS_XMLDOM.DOMDocument;

Parameters

ARPLS69401Table 166-43 MAKEDOCUMENT Function Parameters

Parameter Description

res

XDBResource


ARPLS69402

SAVE Procedure

This procedures updates the resource with any modifications.

Syntax

DBMS_XDBRESEROUCE.SAVE (
   res   IN    XDBResource);

Parameters

ARPLS69403Table 166-44 SAVE Procedure Parameters

Parameter Description

res

XDBResource


ARPLS69404

SETACL Procedure

This procedure sets the ACL of the given XDBResource to the path specified.

Syntax

DBMS_XDBRESEROUCE.SETACL (
   res      IN OUT  XDBResource, 
   ACLPath  IN      VARCHAR2);

Parameters

ARPLS69405Table 166-45 SETACL Procedure Parameters

Parameter Description

res

XDBResource

ACLPath

Absolute path of the new ACL


ARPLS69406

SETAUTHOR Procedure

This procedure sets the author of the given XDBResource to the specified string.

Syntax

DBMS_XDBRESEROUCE.SETAUTHOR (
   res     IN OUT  XDBResource, 
   author  IN      VARCHAR2);

Parameters

ARPLS69407Table 166-46 SETAUTHOR Procedure Parameters

Parameter Description

res

XDBResource

author

Author


ARPLS69408

SETCHARACTERSET Procedure

This procedure sets the character set of the given XDBResource to a specified character set.

Syntax

DBMS_XDBRESEROUCE.SETCHARACTERSET (
   res      IN OUT  XDBResource, 
   charSet  IN      VARCHAR2);

Parameters

ARPLS69409Table 166-47 SETCHARACTERSET Procedure Parameters

Parameter Description

res

XDBResource

charset

New character set


ARPLS69410

SETCOMMENT Procedure

This procedure sets a comment associated with the given XDBResource.

Syntax

DBMS_XDBRESEROUCE.SETCOMMENT (
   res      IN OUT  XDBResource, 
   comment  IN      VARCHAR2);

Parameters

ARPLS69411Table 166-48 SETCOMMENT Procedure Parameters

Parameter Description

res

XDBResource

comment

New comment


ARPLS69412

SETCONTENT Procedures

This procedurereplaces the contents of the given resource with the given datatype.

Syntax

DBMS_XDBRESEROUCE.SETCONTENT (
   res      IN OUT  XDBResource, 
   data     IN      BFILE,
   csid     IN      NUMBER);

DBMS_XDBRESEROUCE.SETCONTENT (
   res      IN OUT  XDBResource, 
   data     IN      BLOB,
   csid     IN      PLS_INTEGER);

DBMS_XDBRESEROUCE.SETCONTENT (
   res      IN OUT  XDBResource, 
   data     IN      CLOB);

DBMS_XDBRESEROUCE.SETCONTENT (
   res      IN OUT  XDBResource, 
   data     IN      REF SYS.XMLType,
   sticky   IN      BOOLEAN := TRUE);

DBMS_XDBRESEROUCE.SETCONTENT (
   res      IN OUT  XDBResource, 
   data     IN      VARCHAR2);

DBMS_XDBRESEROUCE.SETCONTENT (
   res      IN OUT  XDBResource, 
   data     IN      SYS.XMLType);

Parameters

ARPLS69413Table 166-49 SETCONTENT Procedure Parameters

Parameter Description

res

XDBResource

data

Data input as BFILE, BLOB, CLOB, string, XMLType

csid

Character set ID of the BFILE, BLOB

sticky

If TRUE creates a sticky REF, otherwise non-sticky


ARPLS69414

SETCONTENTTYPE Procedure

This procedure sets the content-type of the given XDBResource.

Syntax

DBMS_XDBRESEROUCE.SETCONTENTTYPE (
   res         IN OUT  XDBResource, 
   conttype    IN      VARCHAR2);

Parameters

ARPLS69415Table 166-50 SETCONTENTTYPE Procedure Parameters

Parameter Description

res

XDBResource

conttype

New content-type


ARPLS69416

SETCUSTOMMETADATA Procedure

This procedure sets the custom metadata specified by the xpath and namespace to new data.

Syntax

DBMS_XDBRESEROUCE.SETCUSTOMMETADATA (
   res          IN OUT  XDBResource, 
   xpath        IN      VARCHAR2,
   namespace    IN      VARCHAR2, 
   newMetadata  IN      XMLType);

Parameters

ARPLS69417Table 166-51 SETCUSTOMMETADATA Procedure Parameters

Parameter Description

res

XDBResource

xpath

XPath to change

namespace

Namespace to use

newMetadata

New data that should replace the metadata at the given XPath


Usage Notes

The first component of the XPath expression must be "Resource".

ARPLS69418

SETDISPLAYNAME Procedure

This procedure sets the display name of the given XDBResource.

Syntax

DBMS_XDBRESEROUCE.SETDISPLAYNAME (
   res      IN OUT  XDBResource, 
   name     IN      VARCHAR2);

Parameters

ARPLS69419Table 166-52 SETDISPLAYNAME Procedure Parameters

Parameter Description

res

XDBResource

name

New display name


ARPLS69420

SETLANGUAGE Procedure

This procedure sets the language of the given XDBResource.

Syntax

DBMS_XDBRESEROUCE.SETLANGUAGE (
   res      IN OUT  XDBResource, 
   ACLPath  IN      VARCHAR2);

Parameters

ARPLS69421Table 166-53 SETLANGUAGE Procedure Parameters

Parameter Description

res

XDBResource

ACLPath

New path


ARPLS69422

SETOWNER Procedure

This procedure sets the owner of the given XDBResource.

Syntax

DBMS_XDBRESEROUCE.SETOWNER (
   res      IN OUT  XDBResource, 
   owner    IN      VARCHAR2);

Parameters

ARPLS69423Table 166-54 SETOWNER Procedure Parameters

Parameter Description

res

XDBResource

owner

New owner


Usage Notes

The user must have the XDBADMIN privilege to call this subprogram.

Reader Comment

   

Comments, corrections, and suggestions are forwarded to authors every week. By submitting, you confirm you agree to the terms and conditions. Use the OTN forums for product questions. For support or consulting, file a service request through My Oracle Support.

Hide Navigation

Quick Lookup

Database Library · Master Index · Master Glossary · Book List · Data Dictionary · SQL Keywords · Initialization Parameters · Advanced Search · Error Messages

Main Categories

This Page

  • Using DBMS_XDBRESOURCE
  • Summary of DBMS_XDBRESOURCE Subprograms
    • FREERESOURCE Procedure
    • GETACL Function
    • GETACLDOCFROMRES Function
    • GETAUTHOR Function
    • GETCHARACTERSET Function
    • GETCOMMENT Function
    • GETCONTENTBLOB Function
    • GETCONTENTCLOB Function
    • GETCONTENTREF Function
    • GETCONTENTTYPE Function
    • GETCONTENTXML Function
    • GETCONTENTVARCHAR2 Function
    • GETCREATIONDATE Function
    • GETCREATOR Function
    • GETCUSTOMMETADATA Function
    • GETDISPLAYNAME Function
    • GETLANGUAGE Function
    • GETLASTMODIFIER Function
    • GETMODIFICATIONDATE Function
    • GETOWNER Function
    • GETREFCOUNT Function
    • GETVERSIONID Function
    • HASACLCHANGED Function
    • HASAUTHORCHANGED Function
    • HASCHANGED Function
    • HASCHARACTERSETCHANGED Function
    • HASCOMMENTCHANGED Function
    • HASCONTENTCHANGED Function
    • HASCONTENTTYPECHANGED Function
    • HASCREATIONDATECHANGED Function
    • HASCREATORCHANGED Function
    • HASCUSTOMMETADATACHANGED Function
    • HASDISPLAYNAMECHANGED Function
    • HASLANGUAGECHANGED Function
    • HASLASTMODIFIERCHANGED Function
    • HASMODIFICATIONDATECHANGED Function
    • HASOWNERCHANGED Function
    • HASREFCOUNTCHANGED Function
    • HASVERSIONIDCHANGED Function
    • ISFOLDER Function
    • ISNULL Function
    • MAKEDOCUMENT Function
    • SAVE Procedure
    • SETACL Procedure
    • SETAUTHOR Procedure
    • SETCHARACTERSET Procedure
    • SETCOMMENT Procedure
    • SETCONTENT Procedures
    • SETCONTENTTYPE Procedure
    • SETCUSTOMMETADATA Procedure
    • SETDISPLAYNAME Procedure
    • SETLANGUAGE Procedure
    • SETOWNER Procedure

This Document

New and changed documents:
RSS Feed HTML RSS Feed PDF