Get error using a calculated field from Oracle user defined function

Issue Description:

When using an Oracle user defined function in a calculated field, you are getting the following exception.

java.sql.SQLSyntaxErrorException: ORA-00904: "myUDF": invalid identifier

Resolution:

In applicationContext-semanticLayer.xml file under "oracleSQLGenerator" bean section, add:

<entry key="myUDF">
    <value>"myUDF(" + sqlArgs[0] + ")" </value>
</entry>

Ref. Case #00037391