Home » Developer & Programmer » Forms » How to Debug a form (Oracle, 8.1.7,0.0 / Server Manager 3.1.7.0.0 / Windows Server 2003)
How to Debug a form [message #472991] Wed, 25 August 2010 04:01 Go to next message
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
cookiemonster
Messages: 13938
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.
Previous Topic: Narrowing query using checkbox
Next Topic: how to call dll file in oracle developer 10g or 6i
Goto Forum:
  


Current Time: Thu Sep 19 13:05:11 CDT 2024