Re: Error ORA-01001 after reopning a cursor

Hans Zekl wrote:
>
> 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

Is it possible that you have Pro*C option MODE=ANSI (or something else than ORACLE) in effect when using 7.2.2?

-- 

Timo Haatainen
Carelcomp Forest Oy