Hi Friends,
I create a schedule job to run a procedure in oracle 11.1.. I got a error when I run job. this is a daily job
SQL> begin
2 dbms_scheduler.run_job('test',TRUE);
3 end;
4 /
begin
*
ERROR at line 1:
ORA-06550: line 1, column 765:
PLS-00103: Encountered the symbol "TEST_PERSON" when expecting one of the
following:
:= . ( @ % ; immediate
The symbol ":=" was substituted for "TEST_PERSON" to continue.
ORA-06512: at "SYS.DBMS_ISCHED", line 185
ORA-06512: at "SYS.DBMS_SCHEDULER", line 486
ORA-06512: at line 2
job code as
begin
DBMS_SCHEDULER.CREATE_JOB(
job_name=>'test',
job_type => 'PLSQL_BLOCK',
job_action => 'begin EXECUTE TEST_PERSON(); end;',
start_date=>TRUNC(SYSDATE)+23/24,
repeat_interval=> 'FREQ=daily; INTERVAL=30',
/* next night at 11:00 PM */
comments => 'Explicit LOCK');
END;
I can successful run EXECUTE TEST_PERSON(); in sqlplus and works well. what is wrong setting in DBMS_SCHEDULER ?
Thanks help in advance
newdba