PL/SQL Packages and Types Reference 10g Release 1 (10.1) Part Number B10802-01 |
|
|
View PDF |
The DBMS_TRANSFORM
package provides an interface to the message format transformation features of Oracle Advanced Queuing.
See Also:
Oracle Streams Advanced Queuing User's Guide and Reference for more on message format transformations. |
This chapter contains the following topic:
Subprograms | Description |
---|---|
Creates a transformation that maps an object of the source type to an object of the destination type | |
Drops the given transformation | |
Modifies an existing transformation |
This procedure creates a transformation that maps an object of the source type to an object of the target type. The transformation expression can be a SQL expression or a PL/SQL function. It must return an object of the target type.
DBMS_TRANSFORM.CREATE_TRANSFORMATION ( schema VARCHAR2(30), name VARCHAR2(30), from_schema VARCHAR2(30), from_type VARCHAR2(30), to_schema VARCHAR2(30), to_type VARCHAR2(30), transformation VARCHAR2(4000));
DBMS_TRANSFORM
. The user must also have execute privileges on the user defined types that are the source and destination types of the transformation. In addition, the user must also have execute privileges on any PLSQL function being used in the transformation function.source.user_data
.This procedure drops the given transformation.
DBMS_TRANSFORM.DROP_TRANSFORMATION ( schema VARCHAR2(30), name VARCHAR2(30));
Parameter | Description |
---|---|
|
Specifies the schema of the transformation. |
|
Specifies the name of the transformation. |
This procedure modifies the transformation expression for the given transformation.
DBMS_TRANSFORM.MODIFY_TRANSFORMATION ( schema VARCHAR2(30), name VARCHAR2(30), attribute_number INTEGER, transformation VARCHAR2(4000));
attribute_number
of 0. The new transformation may also be specified for each attribute of the target type.