In article <7gmo5n$j9$1_at_birch.prod.itd.earthlink.net>,
"Stan" <sbrubaker_at_earthlink.net> wrote:
> I'm using Personal Oracle 8.0.4 with PL/SQL on NT. According to the
> documentation I've read, for any SELECT, UPDATE, DELETE, OR INSERT statement
> oracle opens and closes an implicit cursor automatically.
>
> Nonetheless, I'm getting the dreaded "maximum open cursors exceeded." My
> statements are running inside a package's procedures and functions. I do
> several hundred SELECTS, INSERTS, UPDATES, DELETES within a transaction. My
> statements are not complex and do not use subqueries.
>
> Apparently, the "automatic closing" doesn't free up the cursors until after
> the commit. I don't understand this. Since you can't use the implicit
> cursor in your program anyway, why does it hang around wasting resources
> until commit or close-connection?
>
> Any suggestions, tips, tricks?
>
> STAN
>
>
Try increasing open_cursors value in the init.ora file (corresponding file for
your database). Default number of open_cursors may not be enough.
-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Tue May 04 1999 - 10:05:24 CDT
