Oracle9i Application Developer's Guide - Advanced Queuing Release 1 (9.0.1) Part Number A88890-02 |
|
Administrative Interface, 11 of 36
Creates a message format transformation. The transformation must be a SQL function with input type from_type
, returning an object of type to_type
. It can also be a SQL expression of type to_type
, referring to from_type
. All references to from_type
must be of the form source.user_data
.
To use this feature, you must be granted execute privileges on dbms_transform
. You must also have execute privileges on the user-defined types that are the source and destination types of the transformation, and have execute privileges on any PL/SQL function being used in the transformation function. The transformation cannot write the database state (that is, perform DML) or commit or rollback the current transaction.
See Chapter 3, "AQ Programmatic Environments" for a list of available functions in each programmatic environment. Use the following syntax references for each programmatic environment:
See Chapter 3, "AQ Programmatic Environments" for a list of available functions in each programmatic environment. Examples are provided in the following programmatic environments:
dbms_transform.create_transformation(schema => 'scott', name => 'test_transf', from_schema => 'scott', from_type => 'type1', to_schema => 'scott', to_type => 'type2', transformation => 'scott.trans_func(source.user_data)');
Or you can do the following:
dbms_transform.create_transformation(schema => 'scott', name => 'test_transf', from_schema => 'scott', from_type => 'type1, to_schema => 'scott', to_type => 'type2', transformation => 'scott.type2(source.user_data.attr2, source.user_data.attr1)');
No example is provided with this release.
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|