Hi all
I have a serious issue popping now and then
In my application with J2EE and Oracle 9i whenever we execute a search
page I get an sql exception as unable to allocate memory 8064 bytes
I am aware that when we leave a cursor unclosed there would be leakage
of memory
However iam closing the cursor before closing the connection in java
only
So how to resolve this issue as this appears on specific search
criterias
Also can we trace the memory allocated when a cursor query has been
executed not in SQL but inside a PLSQL procedure
I am not able to find a way to resolve this and hence waiting for any
help for it
Thanks
maha




Confidentiality Notice

The information contained in this electronic message and any attachments to this message are intended
for the exclusive use of the addressee(s) and may contain confidential or privileged information. If
you are not the intended recipient, please notify the sender at Wipro or [Email address protected] immediately
and destroy all copies of this message and any attachments.

Oracle LazyDBA home page