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