Sample Header Ad - 728x90

PLS-00306: wrong number or types of arguments in call to 'CREATE_JOB'

0 votes
1 answer
1899 views
we are getting this error when we try to create this scheduler_job but we try to create it give us this error:
BEGIN
  DBMS_SCHEDULER.CREATE_JOB
(  job_name=>'PROC_TKN_WA_FIX_ARREARS',
   job_type=>'STORED_PROCEDURE',
   ownname=>'BUSINESSDATA_ARGENTINA' ,
   job_action=>'BEGIN BUSINESSDATA_ARGENTINA.PROC_TKN_WA_FIX_ARREARS; END;',
   start_date=> SYSTIMESTAMP,
   repeat_interval=>'FREQ=DAILY;BYHOUR=11',
   comments=>'Proc diario 11am'
);
END;
/
ERROR at line 2:
ORA-06550: line 2, column 3:
PLS-00306: wrong number or types of arguments in call to 'CREATE_JOB'
ORA-06550: line 2, column 3:
PL/SQL: Statement ignored
Any ideas what are we doing wrong??
Asked by Daniel Soto (3 rep)
Jan 12, 2023, 04:32 PM
Last activity: Jan 12, 2023, 09:30 PM