ORA-01000: maximum open cursors exceeded

From: Oliver Neumann <no_at_no.com>
Date: Fri, 16 Jun 2006 10:36:48 +0200
Message-ID: <e6tqhg$e37$01$1@news.t-online.com>

Hey there,

i've programmed a tool which handles databaserows like delete/create etc. The whole thing is working very well till now. Im actually building scripts which generates plenty of new rows and now im getting this error:

Im using Oracle DB10g on a W2000Pro-Machine with 2.5GB Ram.

Each row is created with getting a new available PrimaryKey for the table with:

SELECT <seqName>.nextval FROM dual

<seqName> is the name of the sequence which is used to create a new unique PKey.
Its created by:
CREATE SEQUENCE "<seqName>" INCREMENT BY 1 START WITH 1 NOMAXVALUE NOMINVALUE NOCYCLE Is someone able to give me a hint whats wrong ? Im not this deep into oracle-dbs at all.

thanks in advance,
oliver Received on Fri Jun 16 2006 - 03:36:48 CDT