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

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