/*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