The PowerBuilder application cannot use an Oracle database while using the Outer Join (OJ) syntax of SQL92 (specifying ANSI_Escape as the Outer Join Syntax). Otherwise, if an Outer Join is specified for a DataWindow, there will be an Outer Join error when attempting to retrieve data to the DataWindow. This is because Oracle’s JDBC drivers do not support Outer Join syntax {oj outerjoin}.
Workaround: (1) Select the ANSI or PB option in the Outer Join Syntax drop-down list in the Syntax tab of the Database Profile Setup dialog box. (2) Move the syntax into 3-tier NVO, apply the Oracle native driver, and then workaround the DataWindow syntax using the SetFullState and GetFullState functions.
