Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> srw.run_report

srw.run_report

From: <rousebr_at_my-dejanews.com>
Date: Wed, 05 May 1999 15:19:31 GMT
Message-ID: <7gpnhu$l4a$1@nnrp1.dejanews.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US