in reply to Closing Oracle cursors
How are you opening these cursors? Are they explicitly opened inside of function/procedure calls or are you opening and closing them in SQL passed to DBI?
If the former, make sure the functions and procedures you call properly close their own cursors. If the latter, make sure you close your own cursors.
I'm currently running many large PL/SQL programs (with many cursors) on AIX running Oracle 9i and have not encountered any max cursor problems. What platform and version of Oracle are you running?
If the former, make sure the functions and procedures you call properly close their own cursors. If the latter, make sure you close your own cursors.
I'm currently running many large PL/SQL programs (with many cursors) on AIX running Oracle 9i and have not encountered any max cursor problems. What platform and version of Oracle are you running?
--------------
"But what of all those sweet words you spoke in private?"
"Oh that's just what we call pillow talk, baby, that's all."
"But what of all those sweet words you spoke in private?"
"Oh that's just what we call pillow talk, baby, that's all."
|
---|
Replies are listed 'Best First'. | |
---|---|
Re^2: Closing Oracle cursors
by mickey (Acolyte) on Apr 19, 2005 at 17:29 UTC | |
by Transient (Hermit) on Apr 19, 2005 at 18:00 UTC | |
by mickey (Acolyte) on Apr 19, 2005 at 18:48 UTC | |
by Transient (Hermit) on Apr 19, 2005 at 18:57 UTC | |
by mickey (Acolyte) on Apr 19, 2005 at 19:26 UTC | |
|
In Section
Seekers of Perl Wisdom