Oracle | DBMS_XDB

Oracle DBMS_XDB_CONTENT 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 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;

      /

      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