Oracle | DBMS_CLOBUTIL

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

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