Oracle | DBMS_LOB_AM

Oracle DBMS_LOB_AM_PRIVATE 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 LOB Archive Management for DBFS file system

AUTHID DEFINER

Dependencies

DBMS_ASSERT	DBMS_DBFS_CONTENT_PROPERTIES_T	DBMS_TYPES
DBMS_DBFS_CONTENT	DBMS_DBFS_CONTENT_PROPERTY_T	PLITBLM

Documented No

Exceptions

Error Code	Reason
ORA-64002	specified path is invalid

First Available Not known

Security Model Owned by SYS with EXECUTE granted to the DBFS_ROLE role

Source {ORACLE_HOME}/rdbms/admin/prvtpspi.plb

Subprograms

CREATEFILE	GETFILE	ISSTREAMABLE
DELETEFILE	GETLENGTH	SETCHARSETID

CREATEFILE

Undocumented dbms_lob_am_private( path IN VARCHAR2, loc IN BLOB);

TBD

DELETEFILE

Undocumented dbms_lob_am_private(path IN VARCHAR2);

TBD

GETFILE

Undocumented dbms_lob_am_private( path IN VARCHAR2, loc IN OUT BLOB);

TBD

GETLENGTH

Undocumented

Example at right not based on the required DBFS file system dbms_lob_am_private( path IN VARCHAR2, length OUT NUMBER);

DECLARE

       outVal NUMBER;

      BEGIN

        dbms_lob_am_private.getLength('/u01/app/oracle', outVal);

        dbms_output.put_line(TO_CHAR(outVal));

      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 3939

      ORA-06512: at "SYS.DBMS_LOB_AM_PRIVATE", line 27

      ORA-06512: at line 4

ISSTREAMABLE

Undocumented dbms_lob_am_private( path IN VARCHAR2, streamable OUT NUMBER);

TBD

SETCHARSETID

Undocumented dbms_lob_am_private( path IN VARCHAR2, csetid IN NUMBER);

TBD