ORA-27412 - need another set of eyes
Oracle 12.1.0.2.0 Standard Edition 2
ASM 12.1.0.2 – No ASM, no clustering.
Oracle Linux 6
Below is complete output of execution of procedure, including procedure code. Information is pulled from dba_scheduler_jobs, then fed to sub-procedure LIST_NEXT_RUN_DATES to project the time of execution for the next ‘n’ days. Procedure is failing on one particular job evaluation, as shown. I cannot spot the problem.
SQL> set serverout on echo on verify onSQL> DECLARE 2 sqlstmt varchar2(2000); 3 -- 4 PROCEDURE list_next_run_dates ( 5 i_next_run_date IN TIMESTAMP WITH TIME ZONE, 6 i_repeat_interval IN VARCHAR2, 7 i_date_count IN INTEGER DEFAULT 8,