I've been using Oracle SQL developer for about 5 months, i'm new to oracle so there is probably a thousand things i'm doing wrong however one thing that is a constant pain is getting the "Maximum Open Cursors Exceeded" error message.
I get this error when i've been in a session for a while and have been opening tables, switching between views etc (basically just using the thing)
I have to then end the application and reopen it which, when you're in the middle of something is a huge pain.
So, my question.
What IS all this max open cursors stuff?
Why does it happen?
How can i stop it happening?
As i said, i'm new to all this oracle stuff and am trying to be extra diplomatic with the DBAs so as not to annoy them too much so i don't really want to be constantly asking them questions (hence coming here!)