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
Last activity: Jan 12, 2023, 09:30 PM