Home » Developer & Programmer » Reports & Discoverer » Debug Oracle Report in Oracle Forms (Oracel Report 9i)
Debug Oracle Report in Oracle Forms [message #406598] Thu, 04 June 2009 17:23 Go to next message
vmmn
Messages: 4
Registered: June 2009
Location: NA
Junior Member
I am running the Oracle Report 9i from Oracle Forms 9i and need to debug the values from the report. I was trying to use srw.message but didn't receive any results of course. Please help me to solve the problem.

Thanks in advance
Re: Debug Oracle Report in Oracle Forms [message #406620 is a reply to message #406598] Fri, 05 June 2009 00:26 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
How do you "debug values from the report"? What values? What is the problem, actually? Could you describe it?
Re: Debug Oracle Report in Oracle Forms [message #406748 is a reply to message #406620] Fri, 05 June 2009 10:39 Go to previous messageGo to next message
vmmn
Messages: 4
Registered: June 2009
Location: NA
Junior Member
I ran the Report from the Form. The Report is sporadically displaying the wrong fringe rate in the column heading. You can run one time and the value is correct. When you ran another time after the value will be by 0.1 different. No consistency. I am trying to display the value to output. How I can check the path to the output of the message? Here is example of the function I am trying to display the values from using srw.message:

function Reg_FringeFormula return Number is
begin
if :pay_type != 'H' then
if :cnt_rows = 0 then
return null;
else
return(:reg_fringe/:cnt_rows);
end if;
else
return null;
srw.message(112,'reg fringe'||:reg_fringe);
srw.message(112,'cnt_rows'||:cnt_rows);
end if;

end;
Re: Debug Oracle Report in Oracle Forms [message #406771 is a reply to message #406748] Fri, 05 June 2009 15:04 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Move SRW.MESSAGE in front of the RETURN statement(s) because - once RETURN is executed, no further line from the procedure is reached. In other words, your code NEVER came to SRW.MESSAGE.
Re: Debug Oracle Report in Oracle Forms [message #406772 is a reply to message #406771] Fri, 05 June 2009 15:27 Go to previous messageGo to next message
vmmn
Messages: 4
Registered: June 2009
Location: NA
Junior Member
Thanks for advice. I did. How I can check the path to the output of the message? I am running the Report through the Form and I don't know where to find the log file.
Re: Debug Oracle Report in Oracle Forms [message #406774 is a reply to message #406772] Fri, 05 June 2009 15:36 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Log file? Which log file?

Can you not run the report from Reports Builder? You probably know parameters passed from a form to this report so ... debug it from Reports Builder. If you can not do that, perhaps you might create a dummy table and insert values from report into it so that you could review them later.
Re: Debug Oracle Report in Oracle Forms [message #407142 is a reply to message #406774] Mon, 08 June 2009 12:20 Go to previous message
vmmn
Messages: 4
Registered: June 2009
Location: NA
Junior Member
Thanks for feedback. I will use your recommendations.

Regards,
Vienna
Previous Topic: "Number of copies" at report
Next Topic: illegal to use long data type in Group
Goto Forum:
  


Current Time: Sun Dec 11 00:42:59 CST 2016

Total time taken to generate the page: 0.08333 seconds