:ORA-01000 (too many open cursors)
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