PL/SQL (MOSC)

MOSC Banner

ORA-27412 - need another set of eyes

edited Mar 26, 2019 2:39PM in PL/SQL (MOSC) 8 commentsAnswered

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,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center