Oracle DBMS_XDB_CONTENT
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 XDB Support Utilities
AUTHID CURRENT_USER
Dependencies
DBMS_DBFS_CONTENT DBMS_DBFS_CONTENT_PROPERTIES_T PLITBLM
DBMS_DBFS_CONTENT_LIST_ITEMS_T DBMS_DBFS_CONTENT_PROPERTY_T UTL_RAW
DBMS_DBFS_CONTENT_LIST_ITEM_T DBMS_LOB  
Documented No
Exceptions
Error Code Reason
ORA-64002 Specified path is invalid
First Available 12.1
Security Model Owned by XDB with EXECUTE granted to PUBLIC
Source {ORACLE_HOME}/rdbms/admin/prvtxsfsclient.plb
Subprograms
 
CREATEDIR
Undocumented

The example, at right, demonstrates that the directories, files, and paths are DBMS_DBFS file system not a file system external to the database
dbms_xdb_content.createDir(path IN VARCHAR2) RETURN NUMBER;
DECLARE
 retVal NUMBER;
BEGIN
  retVal := xdb.dbms_xdb_content.createDir('/home/oracle/test');
  dbms_output.put_line(retVal);
END;
/
DECLARE
*
ERROR at line 1:
ORA-64002: specified path is invalid
ORA-06512: at "SYS.DBMS_DBFS_CONTENT", line 536
ORA-01403: no data found
ORA-06512: at "SYS.DBMS_DBFS_CONTENT", line 527
ORA-06512: at "SYS.DBMS_DBFS_CONTENT", line 3575
ORA-06512: at "SYS.DBMS_DBFS_CONTENT", line 3605
ORA-06512: at "XDB.DBMS_XDB_CONTENT", line 279
ORA-06512: at line 4
 
CREATEFILE
Undocumented dbms_xdb_content.createFile(
path    IN VARCHAR2,
content IN BLOB);
TBD
 
CREATEFILE2
Undocumented dbms_xdb_content.createFile2(path IN VARCHAR2);
TBD
 
CREATEFILE3
Undocumented dbms_xdb_content.createFile3(path IN VARCHAR2);
TBD
 
DELETEDIR
Undocumented dbms_xdb_content.deleteDir(path IN VARCHAR2) RETURN NUMBER;
TBD
 
DELETEFILE
Undocumented dbms_xdb_content.deleteFile(path IN VARCHAR2) RETURN NUMBER;
TBD
 
DELETENODE
Undocumented dbms_xdb_content.deleteNode(path IN VARCHAR2) RETURN NUMBER;
TBD
 
GETALLPROPERTIES
Undocumented dbms_xdb_content.getAllProperties(
path    IN  VARCHAR2,
content OUT BLOB)
RETURN NUMBER;
TBD
 
GETCONTENTBYPATH
Undocumented

Overload 1
dbms_xdb_content.getContentByPath(
path    IN     VARCHAR2,
content IN OUT BLOB);
TBD
Overload 2 dbms_xdb_content.getContentByPath(path IN VARCHAR2) RETURN BLOB;
TBD
 
GETEVERYTHING
Undocumented dbms_xdb_content.getEverything(
path             IN  VARCHAR2,
creationdate     OUT VARCHAR2,
modificationdate OUT VARCHAR2,
guid             OUT VARCHAR2,
content          OUT BLOB,
item_type        OUT NUMBER);
TBD
 
GETPATH
Undocumented

Overload 1
dbms_xdb_content.getPath(
path       IN     VARCHAR2,
properties IN OUT public.dbms_dbfs_content_properties_t,
content       OUT BLOB,
item_type     OUT NUMBER);
TBD
Overload 2 dbms_xdb_content.getPath(
path       IN     VARCHAR2,
properties IN OUT public.dbms_dbfs_content_properties_t,
amount     IN OUT NUMBER,
offset     IN     NUMBER,
content       OUT RAW);
TBD
 
GETPROPERTY
Undocumented dbms_xdb_content.getProperty(
path     IN VARCHAR2,
datetype IN VARCHAR2)
RETURN VARCHAR2;
TBD
 
GETTYPE
Undocumented dbms_xdb_content.getType(path IN VARCHAR2) RETURN NUMBER;
TBD
 
LIST
Undocumented dbms_xdb_content.list(path IN VARCHAR2) RETURN public.dbms_dbfs_content_list_items_t;
TBD
 
RENAMEPATH
Undocumented dbms_xdb_content.renamePath(
oldpath IN VARCHAR2,
newpath IN VARCHAR2)
RETURN NUMBER;
TBD

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_DBFS_CONTENT
DBMS_XDB
DBMS_XDBREPOS
DBMS_XDB_ADMIN
DBMS_XDB_CONFIG
DBMS_XDB_CONSTANTS
DBMS_XDB_PRINT
DBMS_XDB_UTIL
DBMS_XDB_VERSION
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-2021 Daniel A. Morgan All Rights Reserved
  DBSecWorx