| Error handling in Oracle Reports [message #451617] |
Thu, 15 April 2010 13:49  |
jfsaucier
Messages: 20
Registered: June 2009
Location: Quebec
|
Junior Member |
|
|
Hi,
I want to know if there is a way for our development team to know the status of a report when it's launched from Forms. After reviewing rp2rro.pll code, there seems to be no way of doing that...
Here is some pseudo-code from what I would like to do in Forms. (I am not a developer  :
launch report
status = get_status_from_launched_report
if status == ok
do something
else
do something else
end
For the moment, all I miss is the way to get_status_from_launched_report...
Thanks a lot for your help.
|
|
|
|
| Re: Error handling in Oracle Reports [message #451623 is a reply to message #451617] |
Thu, 15 April 2010 15:00  |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
|
If your developers use RUN_REPORT_OBJECT to run the report, they might also use REPORT_OBJECT_STATUS to check what's being done. Possible results are running, canceled, finished, opening_report, enqueued, invalid_job, terminated_with_error, crashed. Would that be enough?
|
|
|
|
|
|
|
|
| Re: Error handling in Oracle Reports [message #451702 is a reply to message #451617] |
Fri, 16 April 2010 04:31 |
siddiqui88
Messages: 18
Registered: July 2009
Location: Pakistan
|
Junior Member |
|
|
DECLARE
param_id PARAMLIST;
BEGIN
param_id:=CREATE_PARAMETER_LIST('tmpdata');
ADD_PARAMETER(param_id,p_status',TEXT_PARAMETER,:status);
ADD_PARAMETER(param_id,'PARAMFORM',TEXT_PARAMETER,'NO');
Add_Parameter(param_id, 'MAXIMIZE', TEXT_PARAMETER, 'YES');
RUN_PRODUCT(REPORTS,
'Report_name',
SYNCHRONOUS,
RUNTIME,
param_id,
NULL);
DESTROY_PARAMETER_LIST(param_id);
END;
use this code-------
[EDITED by LF: applied [code] tags]
[Updated on: Fri, 16 April 2010 04:53] by Moderator Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
