Re: Maximum Open Cursors Exceeded??

In article <8t7idl$fnr$1_at_crchh14.us.nortel.com>,   "Vemula, Srinivas " <svemula_at_nortelnetworks.com> wrote:
> Is there a Rule of thumb to get rid of this problem??? We checked all
 our
> stored procedures and made sure we explicitly close the cursors after
 we are
> done.

In addition to kal121's suggestion about increasing the max number of cursors, how is your application calling these stored procedures (i.e. is OCI/ODBC/OLE DB/JDBC/etc. involved or is this straight PL/SQL)?

--
Justin Cave - Oracle ODBC Development

Opinions expressed herein are my own and may not reflect those of
Oracle Corporation.


Sent via Deja.com http://www.deja.com/
Before you buy.