Re: ORA-01000: maximum open cursors exceeded

Oliver Neumann schreef:
> 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
>
>

Well, increase the number, then.
They don't cost anything, until you actually use a cursor. Oracle does not need resources to allow for a greater maximum than you use now.

If you wrote the application, make sure cursors are closed (explicit cursors, that is)

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...