Problem:

FETCH PREVIOUS and FETCH PRIOR not working using Oracle OCI

If you attempt to do the scrolloption static and the declare mycursor static

If you set the following directives; sql(usecurlib=ifneeded) and sql(usecurlib=yes)

when a scrolloption static you get a sql error on the open

The fetch prior  will give the next record not previous.

Resolution:

OpenESQL does not support use of scrollable cursors with Oracle OCI, i.e. when the application is compiled with the SQL(TARGETDB=ORACLEOCI) directive.

The Database Access manual lists OpenESQL functionality which isn't supported with Oracle OCI.