| Debug Oracle Report in Oracle Forms [message #406598] |
Thu, 04 June 2009 17:23  |
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 #406748 is a reply to message #406620] |
Fri, 05 June 2009 10:39  |
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;
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
