Upgrading from 5.0 / Pro*Fortran ORA-1041 problem

We've encountered a problem upgrading from Oracle 5.0 to 7.0.16. We are using PRO*Fortran as our application interface and have encountered a ORA-01041 error. This error occurs when, while using a cursor to retrieve data, we get a no data found error (ORA-1043) and then try to close the cursor. It is when we close the cursor that we get the 1041 error. This code appeared to work fine in version 5. Extracting the key portions of the code to a stand alone test driver makes the problem code work but I can find no differences that should make any difference in how the code functions.

Stepping through the code I could find no problems. Stepping through the close cursor call, I could see the error code getting set however I cannot see the source code (as you know Oracle doesn't provide source code). The Oracle call that is failing is SQLFOR/SQLFX3 (params).

Any help you can give would be very much appreciated. (I would appeciate E-mail replies but I will check the net too.)

        thanks in advance!!! Received on Wed Sep 07 1994 - 01:50:52 CEST