Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-01000: maximum open cursors exceeded
Hi
I think that your transaction is too long. The cursor used to get the sequence number is not being closed until the transaction commits.
Regards
Denis
Oliver Neumann wrote:
> 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:
>
> ORA-01000: maximum open cursors exceeded
>
>
> 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 - 04:32:05 CDT