Issue with DATE variable in debug - Allround Automations forums

/*I have submitted this to support, but hoping someone on here might have a quick answer.*/

I am a brand new user of PL/SQL Developer. I have just gotten started debugging on a legacy procedure. I am witnessing something that seems wrong or broken.

I have a procedure that is replicating data from one database to another. I get the next start time, v_StartTime by (get last endtime, add 1 second (in days)):

SELECT endtime
INTO v_StartTime
FROM LU_REPLICATION_CONTROL
WHERE procedurename = v_ProcName;

v_StartTime := v_StartTime + 1 / (24 * 60 * 60);

INSERT INTO lu_sch_log
(PROCEDURENAME, STARTTIME, ENDTIME, SP_ST, SP_ET, TIMESTAMP)
VALUES
(v_ProcName,
v_StartTime,
v_EndTime,
process_start,
SYSDATE,
SYSDATE);

When I look at the value of v_StartTime during debug, I see

It seems like a separate setting for the DATE FORMAT is required for the debugger? I found the DATE and TIME FORMAT options for the UI, but this did not seem to affect variables seen during debugging.

Keehan

Hi,

search for "debug date format" in this forum

and you'll find some topics like

http://www.allroundautomations.com/ubb/ultimatebb.php?ubb=get_topic;f=3;t=005327

with this hint from Marko.

Code

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;

HTH