Oracle DBMS_CLOBUTIL
Version 26ai

General Information
Library Note Morgan's Library Page Header
The best Oracle News for FY2026

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?
Purpose Undocumented
AUTHID CURRENT_USER
Dependencies
DBMS_LOB DBMS_XSLPROCESSOR URITYPE
DBMS_XDB_UTIL DBMS_XSLPROCESSOR_LIB UTL_FILE
DBMS_XMLDOM URIFACTORY UTL_RAW
DBMS_XMLPARSER    
Documented No
First Available 12.1
Security Model Owned by XDB with EXECUTE granted to PUBLIC

Direct access to this package is prevented by an Accessible By clause.
Source {ORACLE_HOME}/rdbms/admin/prvtxslp.plb
Subprograms
 
CLOB2URL
Undocumented

This package may be protected with an ACCESSIBLE BY clause
dbms_clobutil.clob2url(
cl      IN CLOB,
url     IN VARCHAR2,
basedir IN VARCHAR2,
csid    IN NUMBER);
conn / as sysdba

ALTER USER xdb IDENTIFIED BY xdb ACCOUNT UNLOCK;
exec xdb.dbms_clobutil.clob2url('Test', 'www.test.com', 'test', 1);
     *
PLS-00904: insufficient privilege to access object DBMS_CLOBUTIL

ALTER USER xdb IDENTIFIED BY xdb ACCOUNT UNLOCK;

conn xdb/xdb

exec xdb.dbms_clobutil.clob2url('Test', 'www.test.com', 'test', 1);
     *
PLS-00904: insufficient privilege to access object DBMS_CLOBUTIL
 
FP2BLOB
Undocumented dbms_clobutil.fp2blob(
fp        IN utl_file.file_type,
id        IN BINARY_INTEGER,
datatype  IN BINARY_INTEGER,
byte_mode IN BOOLEAN)
RETURN BLOB;
TBD
 
GETBOMOFFSET
Undocumented dbms_clobutil.getBOMOOffset(rawbuf IN RAW) RETURN BINARY_INTEGER;
TBD
 
URL2CLOB
Undocumented dbms_clobutil.url2clob(
url     IN VARCHAR2,
basedir IN VARCHAR2,
csid    IN NUMBER)
RETURN CLOB;
TBD

Related Topics
Built-in Functions
Built-in Packages
DBMS_LOB
UTL_FILE
What's New In 21c
What's New In 26ai

Morgan's Library Page Footer
This site is maintained by Daniel Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2026 Daniel A. Morgan All Rights Reserved