CREATE_TRANSFORMATION Procedure

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 PLSQL function. It must return an object of the target type.

Syntax

DBMS_TRANSFORM.CREATE_TRANSFORMATION (
    schema            VARCHAR2(30),
    name                 VARCHAR2(30),
    to_schema            VARCHAR2(30),
    to_name              VARCHAR2(30),
    from_schema          VARCHAR2(30),
    from_name            VARCHAR2(30),

You can also specify the transformation expression, which returns an object of the target type. If the target type is an ADT, the expression must be a function returning an object of the target type or a constructor expression for the target type. You can choose to not specify a transformation expression and specify a transformation per attribute of the target_type using MODIFY_TRANSFORMATION.

    transformation    VARCHAR2(4000)); 

Parameters

Table 66-2 CREATE_TRANSFORMATION Procedure Parameters

Parameter	Description
schema	Specifies the schema of the transformation
name	Specifies the name of the transformation.
from_schema	Specifies the schema of the source type
from_name	Specifies the source type.
to_schema	Specifies the target type schema
to_type	Specifies the target type.
transformation	Specifies the transformation expression, returning an object of the target type.