Error running reports from forms using run_product.
Date: 2000/03/02
Message-ID: <89mlpe$jpa$1_at_news8.svr.pol.co.uk>#1/1
I have a problem running reports from forms using run_product.
The system is simple, traditional client server. The form running on the client is doing a lot of work amongst which are two reports. The reports need to run asynchronously so as not to delay the form too much. I have two calls to run_product separated by a dozen or so lines of pl/sql.
In each case, run_product is run (.. ,ASYNCHRONOUS, BATCH,..).
The problem is that I keep getting an error message
FRM-41211 SSL integration error .....
Oracle tell me that this is caused by a number of conditions, including insufficient disk space available for reports_tmp (this is not my problem). There final two suggestions are:
- Run the reports synchronously. This is unacceptable as it would make the system unusable.
- Insert a FOR loop between the two calls to run_product. Oracle suggest that FOR i in 1..1000 is generally sufficient. In my case a value of 1000000 makes not appreciable difference.
Forms is version 5.0.6.16 and reports is version 3 (I can't remember the minor version). Oracle tell me that the problem was first reported in Developer release 1 and has also been reported in Developer 6, so upgrading wouldn't seem to be the answer.
Any ideas? Received on Thu Mar 02 2000 - 00:00:00 CET