Hello everybody,
I have a programm when i use nextval multiple times without commiting.
I have to commit at the end only if all registering is done.
If a problem occured before all the registering is done, i make a rollback.
And i obtain this error.
I reproduce this error.
With SQL Developer, i create a sequence and then i get nextval multiple times (200 times),
and always i have this error :
ORA-01000 maximum open cursors exceeded
Like this, i create the sequence,
CREATE SEQUENCE test_sequence MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 2006680770 NOCACHE NOORDER NOCYCLE ;
And then i get netxval multiple times, i run the following request around 200 times :
SELECT test_sequence.NEXTVAL FROM DUAL;
=> I reproduce what i have in my PL SQL procedure;
This error ORA-01000 maximum open cursors exceeded, when i run multiple times the second request.
I would understand :
- which mecanism can explain that ?
- and how to resolve in the code this problem ?
I do not want to increase the number of open cursors allowed.
I want to change my code where in a loop i have to run this instruction:
ORA-01000 maximum open cursors exceeded
Thank you very much in advance,
Thomas
Ce message a été modifié par : 37dc7927-4d40-4dbf-ab3e-7b293d1a44fc