oracle job 定义错误报错,请各位大神指点迷津
我定义了一个存储过程createnewstaff,现在想通过job自动执行以下,可是代码总是报错。请大神指点,存储过程如下:
create or replace procedure proc_auto_exec_job as
begin
declare
job number;
begin
dbms_job.submit(job,'createnewstaff',sysdate,'trunc(sysdate,''mi'')+1/1440');
commit;
DBMS_JOB.RUN(job);
end;
报错如下:
PROCEDURE SDICECS.PROC_AUTO_EXEC_JOB 编译错误
错误:PLS-00103: 出现符号 "end-of-file"在需要下列之一时:
(
begin case declare end exception exit for goto if loop mod
null pragma raise return select update while with
<an identifier> <a double-quoted delimited-identifier>
<a bind variable> << continue close current delete fetch lock
insert open rollback savepoint set sql execute commit forall
merge pipe purge
行:10