3 Replies Latest reply: May 17, 2014 7:38 PM by GhanaApexDeveloper RSS

    Create a transformation rule in Data Loading ...

    bondurs

      Greetings:

       

      When create a transformation rule, what is the syntax you use when the rule type is a PL/SQL Function Body or a SQL Query?  I can't seem to find any documentation or examples of this.

       

      When I choose PL/SQL Function Body, and put the following code in:

       

      begin

        return substr(staging_column,1,10);

      end;

       

      The transformation rules always fails.  Any help would be appreciated.

      We are using APEX 4.2.1.00.08

       

      Thanks,

      Stan