Error ORA-01001 after reopning a cursor

From: Hans Zekl <hz_at_tonbeller.com>
Date: 1997/11/26
Message-ID: <NEWTNews.880548654.22760.hz@pc>#1/1

I have an application in C which reads 6 SQL tables. Before the 2nd reading of the 2nd table I close the cursor and bind the columns for the parameters of the WHERE clause again. Then the application tries to make an OPEN CURSOR. In this moment the error occurs.

I used Pro*c version 1.5 with option MAXOPENCURSORS=50, HOLD_CURSORS=YES AIX Unix version 4.1.5
Oracle RDBMS version 7.2.2

If a use Oracle RDBMS version 7.0.12.1.0 eveything works fine

Any help is welcome. Thank you

Dr. Hans Zekl

Ton Beller GmbH
D-64625 Bensheim
Email: hz_at_tonbeller.com Received on Wed Nov 26 1997 - 00:00:00 CST