How to Debug a form [message #472991] |
Wed, 25 August 2010 04:01 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
kumarvk
Messages: 214 Registered: July 2004
|
Senior Member |
|
|
Dear Experts,
I have a set of code being perform in the package body of a program unit I want to debug step by step and see what values are being stored during executing or running the form
/* Without HP and deposit, Down Payment(GST) = Total(GST) */
if nvl(v_deposit, 0) = 0 and nvl(v_loan_amt, 0) = 0 then
v_gst_fr_dps := 0;
v_gst_hp := 0;
v_gst_bal_pay := v_total_gst;
/* Only without HP, Down Payment(GST) = Total(GST) - Deposit(GST) */
elsif nvl(v_loan_amt, 0) = 0 then
v_gst_fr_dps := round(nvl(v_deposit,0)/
(100+nvl(v_gst_per,0)) *
nvl(v_gst_per,0), 2);
v_gst_hp := 0;
v_gst_bal_pay := v_total_gst - v_gst_fr_dps;
end if;
Like in the above example I want to see the value in v_gst_fr_dps,v_gst_hp,v_gst_bal_pay etc when executing and display in the screen. Can anyone help me?
|
|
|
Re: How to Debug a form [message #472993 is a reply to message #472991] |
Wed, 25 August 2010 04:10 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
cookiemonster
Messages: 13963 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
Simple way is to use messages or alerts to display the values.
You can also try running the form in debug mode but I'm not sure it gives that level of detail.
|
|
|