Oracle DBMS_XDBRESOURCE
Version 21c

General Information
Library Note Morgan's Library Page Header
Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
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 19c
What's New In 20c-21c

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-2022 Daniel A. Morgan All Rights Reserved
  DBSecWorx