Test Window and Date variable

[TenGor]

Hy,

when i test a Package and had to work with Date variables and hover over it then i see in the popup only the date part not the time!

I hope there is a possibility to show Date variable in the defined Format from the preferences, f.e. 'DD.MM.YYYY HH24:MI:SS'.

Thanks in advance
TenGor

 

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

------------------
Marco Kalter
Allround Automations

 

[TenGor]

Hy,

this works fine!

Thanks
TenGor