format of date/time variables in debug sessions

[keckhard]

hi,
is it possible to set the output format of date/time variables for debug sessions (for tiptext and for the variable monitoring grid)? at the moment i just can see variables of this type in the format dd.mm.yy.
thx and best regards, klaus.

 

[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 a specific format, 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;

 

[keckhard]

hi,
it works.
thx and best regards, klaus.