| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|  |  | |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: Strange open cursors for "select null from dual" on Oracle 9i and 10g
"Joel Garry" <joel-garry_at_home.com> wrote in message news:<1113005162.246690.305260_at_f14g2000cwb.googlegroups.com>...
> >After using the system for a while we get an error message on
> >executing a SQL statement. The error message tells that we are running
> 
> >out of cursors. That simple ;-)))
> 
> You must tell us the exact oracle error number.  ORA-1037?  ORA-1000?
> ORA-35564?  Is the error being returned to you or is there something in
> the alert log?  We are neither endodontists nor telepathists here.
> 
> jg
Sorry for answering that late (I have been assigned to an even more pressing problem) and not being more precise. I always thought that there was only 1 error message regarding the number of open cursors - the classic ORA-1000. It is returned to our application which in turn shows it to the user. We did not get it from the alert log or similar. Received on Tue Apr 26 2005 - 09:09:47 CDT
|  |  |