web.show_document problem during mailing a report from a Form [message #682771] |
Wed, 18 November 2020 01:24 |
limig
Messages: 11 Registered: April 2010 Location: Asia
|
Junior Member |
|
|
I am using web.show_document to email a report in pdf format from a form (10G) for several employees. The code is executed in a loop based on the number of employees selected. The reports are getting mailed perfectly in most cases (Report Job Status is 'Successfully run'). But some of them are failing showing different errors: 'REP-300: OCI_INVALID_HANDLE', 'COULD NOT CONNECT TO DATABASE', etc.
Now, is it possible to know/track the employees for whom the report could not run?
Also, executing the report opens up multiple tabs (each for every employee). Can this opening be suppressed? Thanks in advance.
|
|
|