Oracle | DBMS_CLOBUTIL

Oracle DBMS_CLOBUTIL 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 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 means of an Accessible By clause.

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

Subprograms

CLOB2URL	GETBOMOFFSET	URL2CLOB
FP2BLOB

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);

      BEGIN xdb.dbms_clobutil.clob2url('Test', 'www.test.com', 'test', 1); END;

      *

      ERROR at line 1:

      ORA-06550: line 1, column 7:

      PLS-00904: insufficient privilege to access object DBMS_CLOBUTIL

      ORA-06550: line 1, column 7:

      PL/SQL: Statement ignored

      

      ALTER USER xdb IDENTIFIED BY xdb ACCOUNT UNLOCK;

      

      conn xdb/xdb

      

      exec xdb.dbms_clobutil.clob2url('Test', 'www.test.com', 'test', 1);

      BEGIN xdb.dbms_clobutil.clob2url('Test', 'www.test.com', 'test', 1); END;

      *

      ERROR at line 1:

      ORA-06550: line 1, column 7:

      PLS-00904: insufficient privilege to access object DBMS_CLOBUTIL

      ORA-06550: line 1, column 7:

      PL/SQL: Statement ignored

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