Oracle | DBMS_LOB_AM

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

AUTHID CURRENT_USER

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;

      /

      *

      ORA-64002: specified path is invalid

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