Re: Cursor Question

nafallon_at_vax1.tcd.ie wrote:
: Hi all
 

: Perhaps someone can help me with this.
 

: I am running Oracle 6.033 on Interactive UNIX v3.0.
 

: My application first declares all of the cursors that it will need (say five).
: Then as the program runs, these cursors are opened, fetch data, and are closed
: again according to the users selection. All this works fine except when I open
: any cursor a second time, in which case Oracle returns an 'invalid cursor state'
: message (error ORA-01001 ).
: The strange thing however is that the occurance of this error depends on how
: many cursors I declare at the begining of my code.
:
: Stuff deleted ...

  From your examples it sounds like you are running out of memory. You   may want to check to see if Oracle tries to allocate an anticipated   amount of memory on the system Stack or Heap prior to you actually   opening the cursor. If so, this would explain why for every cursor   you declare over four, you can not open that many again. This is   especially apparent since you can only manipulate four (reopen) at   a time.

  Kurt

: Thanks for any help in solving this.
 

: Niall Fallon
: CTS Technology
: Trinity College Dublin
: fallon_at_mee.tcd.ie

--

======================================================================

Kurt A. Zarefoss                     "Anyone who says they can see 
zarefoss_at_guardian.sra.com             through women is missing a lot."
                                                     - Groucho Marx
======================================================================

  "All of the above opinions are strictly my own.  However stupid they
   may be."