Modifying a Transformation

Figure 9-11 Use Case Diagram: Modifying a Transformation

Text description of the illustration adq81435.gif

Purpose

This feature is used to change the transformation function and to specify transformations per an attribute of the target type. If the attribute number 0 is specified, then the transformation expression singularly defines the transformation from the source to target types. All references to from_type must be of the form source.user_data. All references to the attributes of the source type must be prefixed by source.user_data.

Usage Notes

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.