Cursor Question

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. For example :
I declare 5 cursors => I cannot re-ropen the first cursor that I open, any that I open after that I can use as many times as I like. I declare 6 cursors => I cannot re-open the first two cursors that I open, again all the others are ok.

The relationship continues for each new cursor that is declared.

I am not using a precompiler RDA instead) so the suggestion in the 'error messages and codes' manual concerning increasing AREASIZE and MAXOPENCURSORS does not apply (I think)a

I have increased the open_cursors, context_area, db_block_buffers and processes values in init.ora without success.

Thanks for any help in solving this.

Niall Fallon
CTS Technology
Trinity College Dublin
fallon_at_mee.tcd.ie Received on Tue Oct 12 1993 - 16:34:38 CET