:ORA-01000 (too many open cursors)

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

[Quoted] [Quoted] 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                            |
|________________________________________________________________|