timestamp portion not showing when examining variable of date datatype in debug mode

[null0000]

is that a bug or expected behavior of debugger?

 

[Marco Kalter]

It is expected behavior, but it can be enhanced. The date (and time) value is displayed in the nls_date_format. 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;