Oracle DBMS_LOB_AM_PRIVATE
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 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
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

Related Topics
Built-in Functions
Built-in Packages
DBMS_LOB
DBMS_LOBUTIL
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-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx