ORA-01000: maximum open cursors exceeded

[jhui]

Does anyone know anything about this error ?
I have heard that Oracle v 8.0.6 has a cursor 'leak' when using LOBs.
Can anyone confirm this ?
If so, does anyone have a fix, or a link to some Oracle article or patch ?

TIA

Jan Huizinga
Frontix BV

 

[Marco Kalter]

I'm not aware of such a bug, and I can't find it on Oracle MetaLink either. This does not mean that the bug does not exist of course

.

------------------
Marco Kalter
Allround Automations

 

[Ole Petter]

Are you sure you have set value of the "open_cursors" value in the init.ora of the db-server properly high?
I had the same problem, but it disappeared after I increased this parameter value.
Ole Petter