Are you sure it is due to the stored procedure? You can get that error if you don't close all database objects. Make sure you close resultsets, statements, etc in a "finally" block throughout all your code.
On Mon, Mar 21, 2011 at 4:59 PM, Propes, Barry L <barry.l.pro...@citi.com> wrote: > And to this....is it absolutely necessary to use the SYS_REFCURSOR in Oracle? > I use several packages and procesures and never use this! Granted, I may have > many less records than you in your DB table, but I was just wondering. > Perhaps it is. > > >> BTW, my application calls a stored procedure which in turn uses an >> oracle SYS_REFCURSOR. As I know ref cursor can not be closed through code. > > How are you supposed to close that cursor, then? Did you mean you can't close > it through Java code, or you can't even close it through PL/SQL? > >> Once the error is encountered the application is not recovering until >> the application is restarted. > > Sounds like closing the connection and re-initializing it would probably do > the job, too. Is it possible for you to detect the kinds of requests that > will allocate these SYS_REFCURSORs and use a one-time connection instead of > going through the pool? > > - -chris > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.4.10 (MingW32) > Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ > > iEYEARECAAYFAk2HYRkACgkQ9CaO5/Lv0PAOpQCfWY5OKJoRo1C8Ld//bOTpCC3x > t/QAn2qdGxo0uXDU01rf6A+IElsrLDTq > =40df > -----END PGP SIGNATURE----- > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org > For additional commands, e-mail: users-h...@tomcat.apache.org > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org > For additional commands, e-mail: users-h...@tomcat.apache.org > > --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
