Debugger - Date Variables

[Sachin]

Using PL/SQL Developer Version 7.1.1.1339.
The debugger does not display the time section of the date in case of date variables. The "Watch Window" too does not display the time only the date section.

Any suggestions?

 

[Marco Kalter]

The date (and time) value is displayed in the nls_date_format. This is an unfortunate Oracle Server behavior, the debugger doesn't even know that the variable is a date. However, if you want to test procedure xyz and display date variables with time fraction, you can simply modify your test script like this:

begin
    -- Modify the nls_date_format for the session of the test script
    dbms_session.set_nls('nls_date_format','''DD-MM-YYYY HH24:MI:SS''');
    -- Run the procedure
    xyz(p1 => :p1, p2 => :p2);
  end;

I hope this helps.

 

[koja]

I changed the test window template and added the above statement and severall other. Handy!

Is it also posible to modify the testscript code from the right-click test object popup option?

 

[Marco Kalter]

I assume you mean a template for the default code generated for the test script? No, there is currently no functionality for this.

 

[Sachin]

Thanks Marco. I guess that helps me.