Home » Developer & Programmer » Forms » web.show_document problem during mailing a report from a Form (Forms 10g)
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.
Previous Topic: master detail problem
Next Topic: Unable to display push buttons properly on the form
Goto Forum:
  


Current Time: Sat Nov 27 23:40:06 CST 2021