ORA-01002 Fetch Out Of Sequence in Reports 2.5

We have developed our applications on Oracle 7.3 Forms 4.5 and Reports 2.5. We have recently migrated the database to 9.2.0.1.0 but the front end is still Forms 4.5 and Reports 2.5. The application runs in client-server mode and Oracle 7.3 client software is installed on the client machines.

After the above migration, we have been getting ORA-01002 Fetch Out of sequence error while running reports. The error occurs at random i.e. does not occur for the same report and does not occur all the time. The reports do not have any PL/SQL.

I know that the most acceptable solution would be to migrate the front end also to Reports 6i or 9i, but are there are any other solutions ? I was told that there is a patch to be applied for this version of the database, but I could not get additional details.

Featured Post

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime? I'm talking things like:
* Dropping columns
* Shrinking allocated space
* Removing chained blocks and restoring the PCTFREE
* Re-or…

Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface. I made a script to download the Alert Log, look for errors, and email me the trace files. In this article I'll describe what I did and share my script.