Oracle | DBMS_XDB

Oracle DBMS_XDB_CONTENT 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 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	DELETEFILE	GETPATH
CREATEFILE	DELETENODE	GETPROPERTY
CREATEFILE2	GETALLPROPERTIES	GETTYPE
CREATEFILE3	GETCONTENTBYPATH	LIST
DELETEDIR	GETEVERYTHING	RENAMEPATH

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;

      /

      *

      ORA-64002: specified path is invalid

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