MODIFY_TRANSFORMATION Procedure

This procedure modifies (or creates) the mapping for the specified attribute of the target type. The transformation expression must be a SQL expression or a PLSQL function returning the type of the specified attribute of the target type. An attribute number zero must be specified for a scalar target type. If the target type is an ADT, and the attribute number is zero, then the expression must be a PLSQL function returning an object of the target type or a constructor expression for the target type.

Syntax

DBMS_TRANSFORM.MODIFY_TRANSFORMATION (
    schema            VARCHAR2(30)
    name              VARCHAR2(30),
    attribute_number  INTEGER,
    transformation    VARCHAR2(4000));

Parameters

Table 66-3 ADD_ATTRIBUTE_MAP Procedure Parameters

Parameter	Description
schema	Specifies the schema of the transformation
name	Specifies the name of the transformation.
attribute_number	Musts be zero for a scalar target type.
transformation_expression	The transformation expression must be a SQL expression or a PLSQL function returning the type of the specified attribute of the target type.