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 into the DataWindow. This is because Oracle’s JDBC drivers do not support Outer Join syntax {oj outerjoin}.
Workaround:
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.
Move the syntax into 3-tier NVO, apply the Oracle native driver, and then workaround the DataWindow syntax using the SetFullState and GetFullState functions.
