Oracle | DBMS_TRANSFORM

Oracle DBMS_TRANSFORM Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows

Purpose Provides an interface to the message format transformation features of Advanced Queuing.

AUTHID CURRENT_USER

Dependencies

DBMS_ASSERT	DBMS_STANDARD	DBMS_UTILITY
DBMS_LOGREP_UTIL	DBMS_TRANSFORM_INTERNAL	UTL_RAW
DBMS_PRIV_CAPTURE	DBMS_TRANS_LIB

Documented Yes

First Available 9.0

Security Model Owned by SYS with EXECUTE granted to the AQ_ADMINISTRATOR_ROLE and AQ_USER_ROLE roles

Source {ORACLE_HOME}/rdbms/admin/dbmstxfm.sql

Subprograms

COMPUTE_TRANSFORMATION	DROP_TRANSFORMATION	Demo
CREATE_TRANSFORMATION	MODIFY_TRANSFORMATION

COMPUTE_TRANSFORMATION

Undocumented dbms_transform.compute_transformation ( message IN "<ADT_1>", transformation_schema IN VARCHAR2, transformation_name IN VARCHAR2, transformed_message OUT "<ADT_1>");

TBD

CREATE_TRANSFORMATION

Creates a transformation that maps an object of the source type to an object of the destination type dbms_transform.create_transformation ( schema IN VARCHAR2(30), name IN VARCHAR2(30), from_schema IN VARCHAR2(30), from_type IN VARCHAR2(30), to_schema IN VARCHAR2(30), to_type IN VARCHAR2(30), transformation IN VARCHAR2(4000) DEFAULT NULL);

exec dbms_transform.create_transformation('SCOTT', 'MYMAP', 'SCOTT', 'CART_POINT', 'SCOTT', 'POLAR_POINT', 'function_name(parameter)');

      

      PL/SQL procedure successfully completed.

DROP_TRANSFORMATION

Drop a transformation dbms_transform.drop_transformation( schema IN VARCHAR2(30), name IN VARCHAR2(30));

exec dbms_transform.drop_transformation('SCOTT', 'MYMAP');

      

      PL/SQL procedure successfully completed.

MODIFY_TRANSFORMATION

Modify a transformation dbms_transform.modify_transformation ( schema IN VARCHAR2(30), name IN VARCHAR2(30), attribute_number IN NUMBER, transformation IN VARCHAR2(4000));

exec dbms_transform.modify_transformation('aqadmin', 'MYMAP', 2, 'function_name(parameter)');

      

      PL/SQL procedure successfully completed.

Demo

DBMS_TRANSFORM (Demo from $ORACLE_HOME/rdbms/admin/exechae.sql); BEGIN sys.dbms_transform.create_transformation( schema => 'SYS', name => 'haen_txfm_obj', from_schema => 'SYS', from_type => 'ALERT_TYPE', to_schema => 'SYS', to_type => 'VARCHAR2', transformation => 'sys.haen_txfm_text(source.user_data)'); EXCEPTION WHEN OTHERS THEN IF sqlcode = -24184 THEN NULL; ELSE RAISE; END IF; END; / -- which references CREATE OR REPLACE FUNCTION haen_txfm_text(message in sys.alert_type) RETURN VARCHAR2 IS EXTERNAL NAME "kpkhetp" WITH CONTEXT PARAMETERS(context, message, message indicator struct, RETURN OCISTRING) LIBRARY DBMS_HAEVENTNOT_PRVT_LIB;