Oracle DBMS_TRANSFORM


	CODE Oracle Code Library


	JOBS Find Or Post Oracle Jobs


	FORUM Oracle Discussion & Chat

Search the Reference Library pages:

Free
Oracle Magazine
Subscriptions
and Oracle White Papers

Oracle DBMS_TRANSFORM

Version 11.1

General

Purpose

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

Source

{ORACLE_HOME}/rdbms/admin/dbmstxfm.sql

First Available

9.0.1

Dependencies

DBMS_ISCHED_REMDB_JOB	DBMS_TRANS_LIB
DBMS_TRANSFORM_INTERNAL	DBMS_UTILITY

Security Model

Execute is granted to AQ_USER role

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

DROP_TRANSFORMATION

Drop a transformation

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

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

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

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;

Related Topics

DBMS_AQ

DBMS_AQADM

Home : Code Library : Sponsors : Privacy : Terms of Use : Contact Us