Oracle 6 -> Oracle 7

Hi,

        I seem to have a unique problem with Oracle. I would appreciate any help. The problem has arisen during our migration of our system from Oracle 6.0.36 (running PL/SQL version 1) to Oracle 7.0.15 (running PL/SQL version 2). This is on a LAN running Netware.

        The problem is with the following piece of code.

	if (ofen(SQLcurs[cursotId].curarea, 1 /*maximum records in buffer*/))
	{
		//do error processing
	}
	return(0);

The scenario is that I have only one row to retrieve. So when this piece of code is executed the second time, it should result in error processing, because of the retrun value from ofen(). This is exactly what happens in Oracle 6, but in Oracle 7 ofen() returns SQL_SUCCESS ( value of 0).

        I have checked the CDA in both cases. In Oracle 6:
csrc (V2 Return Value) is 4 (which is equivalent to "No Data Found"), csarc (Return Code) is 1403,
csrpc (Rows Processed Count) is 1, as expected.

But in Oracle 7:
csrc is 0,
csarc is 0,
csrpc is 2 (when the maximum number of records in only 1!)

        Can anyone tell me what is going on here? I have talked with Oracle Tech support and they said that I should check the csarc (which is incorrect). I am desperate. I will provide any further clarification as required.

Thanks a lot for your help,
Sanjay
sanjay_at_access.thegroup.net

--

Sanjay Nayar				|e-mail: sanjay_at_thegroup.net
Software Engineer			|tel: (619) 586-1055 (work)
Meridian Corp.				|     (619) 549-9017 (home)
B-K Dynamics Operation			|fax: (619) 586-0424
8996 Miramar Rd., Suite 215		|home: 8451 Westmore Rd., #112
San Diego, CA 92126			|      San Diego, CA 92126