debugger hint date format

[bibi]

when debugging and standing with the mouse over a date variable , a hint is displayed with the value of the date but it is formated according to the db format which is DD-MON-YYYY and not the format set in the preferences window

 

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

You can also set NLS_DATE_FORMAT in your Oracle registry or in AfterConnect.sql.

 

[bibi]

10x