We have developed our applications on Oracle 7.3 Forms 4.5 and Reports 2.5. We have recently migrated the database to 220.127.116.11.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.