Re: Help with cursor error

From: Parris Geiser <parris_at_walleye.esp.bellcore.com>
Date: 1995/05/19
Message-ID: <3pj54v$106_at_athos.cc.bellcore.com>#1/1


Federico R Cabanes (frc7186_at_cs.rit.edu) wrote:
> Hello all:
 

> I was wondering if there was some kind soul on the net who could offer
> some insight into a frustrating problem. We recently set up the Oracle
> 7.1.4 server on an SGI unix platform and migrated our database from a
> VAX platform. Oracle itself seems to be working fine. The problem arises
> when we use Oracle with another software package that makes calls to it.
> After a few queries with this software package, we get the error:
 

> ORA-01001: invalid cursor
 

> This is followed by a slew of cursor related error messages.
> I've increased Oracle's SGA to about 50MB (we have 256MB of RAM) and
> set the OPEN_CURSORS init variable to 500. Is this truly a problem
> of running out of cursor space and if so how do I fix it?
 

> Thanks in advance for your help.
 

> - Federico Cabanes

I've seen this problem before. It occured in our application when an ORACLE commit was done outside of the other software package. In particular, for our case, we were running in an TUXEDO/XA environment. Our application, in certain cases, failed to do the "commit" but it was done by TUXEDO. Afterwards, we got the cursor error in our application. Hope this gives you some clue.

        parris geiser Received on Fri May 19 1995 - 00:00:00 CEST

Original text of this message