We have a question in database programming with Visual Basic and Oracle 8i.
We are using stored procedures(grouped into packages) to get data from the database using the OraOLEDB provider.
We return resultsets from the stored procedures to VB.
During a long operation (lot of calls to different stored procedures) the returned recordset has rs.EOF = True but the request should return some rows.
Inspecting the returned recordset we realized that the "Row-00001 Cannot allocate memory" error was thrown.
Is there any way to know where the error comes from?
-OraOledb provider on Oracle 188.8.131.52.1
-MDAC 2.8 Used
-The error is always produced at a different point in the application
-No error trace appears at server side
-CursorSide = adUseServer