Oracle 18cR3 DBMS_TRANSFORM

Oracle DBMS_TRANSFORM_INTERNAL Version 18.3.0.1

General Information

Library Note

Morgan's Library Page Header

For how many years have you been working with physical servers that are starving your database of the memory necessary to deploy important new performance features such as the Result Cache, Memoptimize Pool, In-Memory Aggregation, In-Memory Column Store, and Full Database Caching? Too long? Contact me to learn how to improve all queries ... not just some queries.

Purpose Advanced Queuing Message Transformation

AUTHID DEFINER

Dependencies

AQ$_TRANS_SEQUENCE	DBMS_TRANSFORM	DBMS_TRANS_LIB
DBMS_AQADM	DBMS_TRANSFORM_EXIMP	DBMS_UTILITY
DBMS_ASSERT	DBMS_TRANSFORM_EXIMP_INTERNAL	DUAL
DBMS_STANDARD

Documented No

First Available Not Known

Security Model Owned by SYS with no privileges granted and secured with an ACCESSIBLE BY clause.

Source {ORACLE_HOME}/rdbms/admin/prvttxfm.plg

Subprograms

GET_IDN_LENGTH	I_DROP_TRANSFORMATION	I_MODIFY_TRANS
I_CREATE_TRANS

GET_IDN_LENGTH

Undocumented

Package secured through an ACCESSIBLE BY clause dbms_transform_internal.get_idn_length RETURN NUMBER;

SELECT dbms_transform_internal.get_idn_length

      FROM dual;

      SELECT dbms_transform_internal.get_idn_length

      *

      ERROR at line 1:

      ORA-06553: PLS-904: insufficient privilege to access object DBMS_TRANSFORM_INTERNAL

I_CREATE_TRANS

Undocumented dbms_transform_internal.i_create_trans( schema IN VARCHAR2, name IN VARCHAR2, from_schema IN VARCHAR2, from_type IN VARCHAR2, to_schema IN VARCHAR2, to_type IN VARCHAR2, transformation IN VARCHAR2, is_import IN BOOLEAN);

TBD

I_DROP_TRANSFORMATION

Undocumented dbms_transform_internal.i_drop_transformation( trans_owner IN VARCHAR2, trans_name IN VARCHAR2);

TBD

I_MODIFY_TRANS

Undocumented dbms_transform_internal.i_modify_trans( schema IN VARCHAR2, name IN VARCHAR2, attribute_number IN NUMBER, transformation IN VARCHAR2, is_import IN BOOLEAN);

TBD