Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Error ORA-01001 after reopning a cursor

Re: Error ORA-01001 after reopning a cursor

From: Timo Haatainen <Timo.Haatainen_at_tietogroup.com>
Date: 1997/11/26
Message-ID: <347C3AC6.7963@tietogroup.com>#1/1

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
Received on Wed Nov 26 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US