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);