Hi all, Here we have a problem , In our application (Java /JSP) all the database updation and retreival are done through Oracle procedures.We obtain a Refrential cursor for retrieving of records from the database to our application. The problem here is that the cursor for all the SQL querries used are left open and we cannot close the cursor explictly in our java code. Hence the after sometime the number of open cursors exceeds the max limit and the application crashes.
Is there some way where we can close the cursor from our application. thanx in advance, Srinivas ___________________________________________________________________________ To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff SERVLET-INTEREST". Archives: http://archives.java.sun.com/archives/servlet-interest.html Resources: http://java.sun.com/products/servlet/external-resources.html LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
