Database Utilities (MOSC)

MOSC Banner

19.13.0.0.0

I created the following scheduler job and getting ORA-27451: CREDENTIAL_NAME cannot be NULL.

Please help me out why am i getting error for SQL

BEGIN

 SYS.DBMS_SCHEDULER.CREATE_JOB

  (

    job_name    => 'NATLAS.TEST'

   ,start_date   => NULL

   ,repeat_interval => NULL

   ,end_date    => NULL

   ,job_class    => 'DEFAULT_JOB_CLASS'

   ,job_type    => 'SQL_SCRIPT'

    ,credential_name => 'NATLAS.SREENI'

   ,job_action   => 'DECLARE


BEGIN


qry:= ''select sysdate from dual;'';

EXECUTE IMMEDIATE qry;


END;

'

   ,comments    => NULL

  );

 SYS.DBMS_SCHEDULER.SET_ATTRIBUTE

  ( name   => 'NATLAS.TEST'

   ,attribute => 'RESTARTABLE'

   ,value   => FALSE);

 SYS.DBMS_SCHEDULER.SET_ATTRIBUTE

  ( name   => 'NATLAS.TEST'

   ,attribute => 'LOGGING_LEVEL'

   ,value   => SYS.DBMS_SCHEDULER.LOGGING_OFF);

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