DBMS_SCHEDULER giving wrong result in oracle version 19
I have created a job to calculate no of days in my HR application. when run the the job with below code it gives correct value
BEGIN
DBMS_SCHEDULER.RUN_JOB(
JOB_NAME => 'ADJUST_VAC_WITH_HOLIDAYS',
USE_CURRENT_SESSION => TRUE);
END;
if the below is used it gives wrong value
BEGIN
DBMS_SCHEDULER.RUN_JOB(
JOB_NAME => 'ADJUST_VAC_WITH_HOLIDAYS',
USE_CURRENT_SESSION => FALSE);
END;
what is the reason for this problem?
0