Oracle DBMS_XDBRESOURCE
Version 21c

General Information
Library Note Morgan's Library Page Header
ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.
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
 
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

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_XDBREPOS
DBMS_XDB_ADMIN
DBMS_XDB_CONFIG
DBMS_XDB_CONSTANTS
DBMS_XDB_CONTENT
DBMS_XDB_PRINT
DBMS_XDB_UTIL
DBMS_XDB_VERSION
DBMS_XEVENT
DBMS_XLSB
What's New In 21c
What's New In 23c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2023 Daniel A. Morgan All Rights Reserved
  DBSecWorx