:ORA-01000 (too many open cursors)

From: Eric Hartzenberg <eric_at_erichome.demon.co.uk>
Date: 1997/04/01
Message-ID: <S2mwsCAIEWQzEwUm_at_erichome.demon.co.uk>#1/1


In article <333A9619.298F_at_ryback.com>, Ken Johnson <kjohnson_at_ryback.com> writes
>Discart Miguel wrote:
>>
>> This message is crossposted to :
>> comp.databases.oracle,comp.databases.oracle.misc,comp.databases.oracle.server,
 comp.databases.oracle.tools
>>
>> Hi to all of you,
>>
>> I need your help, so here is my problem. On a form application
>> (v4.5), I have a lot of fonction which call cursor to populate
>> fields.
>>
>> I use these cursors always in a :
>> FOR c1 IN CURSOR_NAME LOOP
>> my_job
>> END LOOP;
>>
>> The problem is sometimes I got an error ora-01000 (which mean to many
>> cursor open at one time) but that never happen twice the same way. Is
>> the meaning of this error that I don't understand or the use of the
>> DO..LOOP.
>>
>> Anyone got a clue?
>>
>> TIA
>>
>> --
>>
>> ----------------------------------------------------------------
>> Regards,
>> Miguel Discart

Single forms with lots of functionality (many blocks,lookups etc) can eat up your allocation of cursors pretty quickly. Particularly if the user keeps the form open all day (order-entry form , for example). Maybe you could put infrequently used features in subordinate forms. Closing these sub-forms releases the cursors associated with blocks.


| ~~~~~~~~~~~~~~~~~~~~ | ERIC  HARTZENBERG | ~~~~~~~~~~~~~~~~~~~ |     
| Email    : eric_at_erichome.demon.co.uk   Compuserve  : 100073,21 |
| Homepage : www.erichome.demon.co.uk                            |
|________________________________________________________________|
Received on Tue Apr 01 1997 - 00:00:00 CEST

Original text of this message