Debugging PL/SQL

[Gerald]

How can I get the timestamps to show in the date variables in the watches window when running in debug mode?

 

[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.