| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.misc -> srw.run_report
I'm calling another report via a driver-type report using this srw routine.
It's within a loop in the driver, so it can be called multiple times. The
problem is when the run_report starts up the new report it opens cursors that
I don't declare. Unfortunately these cursors never get closed.
Also, the calling report does not define any cursors; all there is in the report are queries. I'm assuming that these cursors are automatically created by the report for the queries.
Is there a way to close these cursors programmatically? I've been told to just bump up the open cursors limit but that really doesn't solve the problem. It just puts it off.
Thanks for any info.
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed May 05 1999 - 10:19:31 CDT
![]() |
![]() |