Oracle | DBMS_XDBRESOURCE

Oracle DBMS_XDBRESOURCE Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows

Purpose Operates on a resource's metadata and contents. This is the user visible package that corresponds with the pragma-d internal XDB.DBMS_XLSB package.

AUTHID CURRENT_USER

Data Types SUBTYPE xdbrestype IS RAW(13); TYPE XDBResource IS RECORD(id xdbrestype);

Dependencies

DBMS_LOB	DBMS_XDB_REPOS	DBMS_XMLDOM
DBMS_XDB	DBMS_XEVENT	XMLTYPE
DBMS_XDBRESOURCE_LIB

Documented No

First Available Not known

Pragmas PRAGMA SUPPLEMENTAL_LOG_DATA(default, NONE)

Security Model Owned by XDB with EXECUTE granted to PUBLIC

Source {ORACLE_HOME}/rdbms/admin/dbmsxres.sql
{ORACLE_HOME}/rdbms/admin/prvtxres.plb

Subprograms (53)

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

FREERESOURCE

Frees any memory associated with an XDBResource dbms_xdbresource.freeResource(res IN xdb.dbms_xdbresource.xdbresource);

TBD

GETACL

Given an XDBResource, returns its ACL as string dbms_xdbresource.getACL(res IN xdb.dbms_xdbresource.xdbresource) RETURN VARCHAR2;

TBD

GETACLDOCFROMRES

Given an XDBResource, returns its ACL as string dbms_xdbresource.getACLDocFromRes(res IN xdb.dbms_xdbresource.xdbresource) RETURN sys.xmltype;

TBD

GETAUTHOR

Given an XDBResource, returns its author dbms_xdbresource.getAuthor(res IN xdb.dbms_xdbresource.xdbresource) RETURN VARCHAR2;

TBD

GETCHARACTERSET

Given an XDBResource, returns its characterset dbms_xdbresource.getCharacterSet(res IN xdb.dbms_xdbresource.xdbresource) RETURN VARCHAR2;

TBD

GETCOMMENT

Given an XDBResource, returns its comment dbms_xdbresource.getComment(res IN xdb.dbms_xdbresource.xdbresource) RETURN VARCHAR2;

TBD

GETCONTENTBLOB

Returns the contents of the resource as a blob dbms_xdbresource.getContentBLOB( res IN xdb.dbms_xdbresource.xdbresource csid OUT BINARY_INTEGER) RETURN BLOB;

TBD

GETCONTENTCLOB

Returns the contents of the resource as a clob dbms_xdbresource.getContentCLOB(res IN xdb.dbms_xdbresource.xdbresource) RETURN CLOB;

TBD

GETCONTENTREF

Returns the contents of the resource as a Ref dbms_xdbresource.getContentRef(res IN xdb.dbms_xdbresource.xdbresource) RETURN sys.xmltype;

TBD

GETCONTENTTYPE

Given an XDBResource, returns its content-type dbms_xdbresource.getContentType(res IN xdb.dbms_xdbresource.xdbresource) RETURN VARCHAR2;

TBD

GETCONTENTVARCHAR2

Returns the contents of the resource as an Varchar2 dbms_xdbresource.getContentVarchar2(res IN xdb.dbms_xdbresource.xdbresource) RETURN VARCHAR2;

TBD

GETCONTENTXML

Returns the contents of the resource as an XMLType dbms_xdbresource.getContentXML(res IN xdb.dbms_xdbresource.xdbresource) RETURN sys.xmltype;

TBD

GETCREATIONDATE

Given an XDBResource, returns its creator dbms_xdbresource.getCreationDate(res IN xdb.dbms_xdbresource.xdbresource) RETURN TIMESTAMP;

TBD

GETCREATOR

Given an XDBResource, returns its creator dbms_xdbresource.getCreator(res IN xdb.dbms_xdbresource.xdbresource) RETURN VARCHAR2;

TBD

GETCUSTOMMETADATA

Undocumented dbms_xdbresource.getCustomMetadata( res IN xdb.dbms_xdbresource.xdbresource, xpath IN VARCHAR2, namespace IN VARCHAR2) RETURN sys.xmltype;

TBD

GETDISPLAYNAME

Given an XDBResource, returns its display name dbms_xdbresource.getDisplayName(res IN xdb.dbms_xdbresource.xdbresource) RETURN VARCHAR2;

TBD

GETLANGUAGE

Given an XDBResource, returns its language dbms_xdbresource.getLanguage(res IN xdb.dbms_xdbresource.xdbresource) RETURN VARCHAR2;

TBD

GETLASTMODIFIER

Given an XDBResource, returns its last modifier dbms_xdbresource.getLastModifier(res IN xdb.dbms_xdbresource.xdbresource) RETURN VARCHAR2;

TBD

GETMODIFICATIONDATE

Given an XDBResource, returns its modification date dbms_xdbresource.getModificationDate(res IN xdb.dbms_xdbresource.xdbresource) RETURN TIMESTAMP;

TBD

GETOWNER

Given an XDBResource, returns its owner dbms_xdbresource.getOwner(res IN xdb.dbms_xdbresource.xdbresource) RETURN VARCHAR2;

TBD

GETREFCOUNT

Given an XDBResource, returns its reference count dbms_xdbresource.getRefCount(res IN xdb.dbms_xdbresource.xdbresource) RETURN BINARY_INTEGER;

TBD

GETVERSIONID

Given an XDBResource, returns its version id dbms_xdbresource.getVersionid(res IN xdb.dbms_xdbresource.xdbresource) RETURN BINARY_INTEGER;

TBD

HASACLCHANGED

Returns TRUE if the ACL of the given resource has changed, else FALSE dbms_xdbresource.hasACLChanged(res IN xdb.dbms_xdbresource.xdbresource) RETURN BOOLEAN;

TBD

HASAUTHORCHANGED

Returns TRUE if the author of the given resource has changed, else FALSE dbms_xdbresource.hasAuthorChanged(res IN xdb.dbms_xdbresource.xdbresource) RETURN BOOLEAN;

TBD

HASCHANGED

Undocumented dbms_xdbresource.hasChanged( res IN xdb.dbms_xdbresource.xdbresource, xpath IN VARCHAR2, bnamespace IN VARCHAR2) RETURN BOOLEAN;

TBD

HASCHARACTERSETCHANGED

Returns TRUE if the charset of the given resource has changed, else FALSE dbms_xdbresource.hasCharacterSetChanged(res IN xdb.dbms_xdbresource.xdbresource) RETURN BOOLEAN;

TBD

HASCOMMENTCHANGED

Returns TRUE if the comment of the given resource has changed, else FALSE dbms_xdbresource.hasCommentChanged(res IN xdb.dbms_xdbresource.xdbresource) RETURN BOOLEAN;

TBD

HASCONTENTCHANGED

Returns TRUE if the contents of the given resource has changed, else FALSE dbms_xdbresource.hasContentChanged(res IN xdb.dbms_xdbresource.xdbresource) RETURN BOOLEAN;

TBD

HASCONTENTTYPECHANGED

Returns TRUE if the content-type of the given resource has changed, else FALSE dbms_xdbresource.hasContentTypeChanged(res IN xdb.dbms_xdbresource.xdbresource) RETURN BOOLEAN;

TBD

HASCREATIONDATECHANGED

Returns TRUE if the creation date of the given resource has changed, else FALSE dbms_xdbresource.hasCreationDateChanged(res IN xdb.dbms_xdbresource.xdbresource) RETURN BOOLEAN;

TBD

HASCREATORCHANGED

Returns TRUE if the creator of the given resource has changed, else FALSE dbms_xdbresource.hasCreatorChanged(res IN xdb.dbms_xdbresource.xdbresource) RETURN BOOLEAN;

TBD

HASCUSTOMMETADATACHANGED

Undocumented dbms_xdbresource.hasCustomMetadataChanged(res IN xdb.dbms_xdbresource.xdbresource) RETURN BOOLEAN;

TBD

HASDISPLAYNAMECHANGED

Returns TRUE if the display name of the given resource has changed, else FALSE dbms_xdbresource.hasDisplayNameChanged(res IN xdb.dbms_xdbresource.xdbresource) RETURN BOOLEAN;

TBD

HASLANGUAGECHANGED

Returns TRUE if the language of the given resource has changed, else FALSE dbms_xdbresource.hasLanguageChanged(res IN xdb.dbms_xdbresource.xdbresource) RETURN BOOLEAN;

TBD

HASLASTMODIFIERCHANGED

Returns TRUE if the last modifier of the given resource has changed, else FALSE dbms_xdbresource.hasLastModifierChanged(res IN xdb.dbms_xdbresource.xdbresource) RETURN BOOLEAN;

TBD

HASMODIFICATIONDATECHANGED

Returns TRUE if the modification date of the given resource has changed, else FALSE dbms_xdbresource.hasModificationDateChanged(res IN xdb.dbms_xdbresource.xdbresource) RETURN BOOLEAN;

TBD

HASOWNERCHANGED

Returns TRUE if the owner of the given resource has changed, else FALSE dbms_xdbresource.hasOwnerChanged(res IN xdb.dbms_xdbresource.xdbresource) RETURN BOOLEAN;

TBD

HASREFCOUNTCHANGED

Returns TRUE if the reference count of the given resource has changed, else FALSE dbms_xdbresource.hasRefCountChanged(res IN xdb.dbms_xdbresource.xdbresource) RETURN BOOLEAN;

TBD

HASVERSIONIDCHANGED

Returns TRUE if the version id of the given resource has changed, else FALSE dbms_xdbresource.hasVersionIDChanged(res IN xdb.dbms_xdbresource.xdbresource) RETURN BOOLEAN;

TBD

ISFOLDER

Checks if the given resource is a folder or not. dbms_xdbresource.isFolder(res IN xdb.dbms_xdbresource.xdbresource) RETURN BOOLEAN;

TBD

ISNULL

Checks if the input res is null dbms_xdbresource.isNull(res IN xdb.dbms_xdbresource.xdbresource) RETURN BOOLEAN;

TBD

MAKEDOCUMENT

Converts the XDBResource to DOMDocument. Can be used in XMLDOM APIs dbms_xdbresource.makeDocument(res IN xdb.dbms_xdbresource.xdbresource) RETURN sys.xdb.dbms_xmldom.domdocument;

TBD

SAVE

Updates the resource with any modifications that were done on it dbms_xdbresource.save(res IN xdb.dbms_xdbresource.xdbresource);

TBD

SETACL

Sets the acl of the given XDBResource to the path specified varchar2 dbms_xdbresource.setACL( res IN OUT xdb.dbms_xdbresource.xdbresource, aclpath IN VARCHAR2);

TBD

SETAUTHOR

Sets the author of the given XDBResource to the specified varchar2 dbms_xdbresource.setAuthor( res IN OUT xdb.dbms_xdbresource.xdbresource, author IN VARCHAR2);

TBD

SETCHARACTERSET

Sets the character set of the given XDBResource to the specified varchar2 dbms_xdbresource.setCharacterSet( res IN OUT xdb.dbms_xdbresource.xdbresource, charset IN VARCHAR2);

TBD

SETCOMMENT

Sets the comment of the given XDBResource to the specified varchar2 dbms_xdbresource.setComment( res IN OUT xdb.dbms_xdbresource.xdbresource, comment IN VARCHAR2);

TBD

SETCONTENT

Replaces the contents of the given resource with the given clob

Overload 1 dbms_xdbresource.setContent( res IN OUT xdb.dbms_xdbresource.xdbresource, data IN CLOB);

TBD

Replaces the contents of the given resource with the given blob

Overload 2 dbms_xdbresource.setContent( res IN OUT xdb.dbms_xdbresource.xdbresource, data IN BLOB, csid IN BINARY_INTEGER);

TBD

Replaces the contents of the given resource with the given XMLType

Overload 3 dbms_xdbresource.setContent( res IN OUT xdb.dbms_xdbresource.xdbresource, data IN sys.xmltype);

TBD

Replaces the contents of the given resource with the given string

Overload 4 dbms_xdbresource.setContent( res IN OUT xdb.dbms_xdbresource.xdbresource, data IN VARCHAR2);

TBD

Replaces the contents of the given resource with the given REF to XMLType

Overload 5 dbms_xdbresource.setContent( res IN OUT xdb.dbms_xdbresource.xdbresource, data IN sys.xmltype, sticky IN BOOLEAN);

TBD

Replaces the contents of the given resource with the given BFILE

Overload 6 dbms_xdbresource.setContent( res IN OUT xdb.dbms_xdbresource.xdbresource, data IN BFILE, csid_bfile IN BINARY_INTEGER);

TBD

SETCONTENTTYPE

Sets the content-type of the given XDBResource to the specified varchar2 dbms_xdbresource.setContentType( res IN OUT xdb.dbms_xdbresource.xdbresource, conttype IN VARCHAR2);

TBD

SETCUSTOMMETADATA

Undocumented dbms_xdbresource.setCustomMetadata( res IN xdb.dbms_xdbresource.xdbresource, xpath IN VARCHAR2, namespace IN VARCHAR2, newmetadata IN sys.xmltype);

TBD

SETDISPLAYNAME

Sets the display name of the given XDBResource to the specified varchar2 dbms_xdbresource.setDisplayName( res IN OUT xdb.dbms_xdbresource.xdbresource, name IN VARCHAR2);

TBD

SETLANGUAGE

Sets the language of the given XDBResource to the specified varchar2 dbms_xdbresource.setLanguage( res IN OUT xdb.dbms_xdbresource.xdbresource, lang IN VARCHAR2);

TBD

SETOWNER

Sets the owner of the given XDBResource to the specified varchar2 dbms_xdbresource.setOwner( res IN OUT xdb.dbms_xdbresource.xdbresource, owner IN VARCHAR2);

TBD