修改成如下即可:DECLARE job1 NUMBER; BEGIN dbms_job.submit(:job1 ,'Myproc;', SYSDATE,'sysdate+1/1440'); COMMIT; END;
[Quote=引用 1 楼 的回复:] 修改成如下即可:SQL code DECLARE job1 NUMBER; BEGIN dbms_job.submit(:job1 ,'Myproc;', SYSDATE,'sysdate+1/1440'); COMMIT; END; 我Run了之后,报如下错误: ORA-06550: 第 4 行, 第 67 列: PLS-00103: Encountered the symbol "" when expecting one of the following: ( 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 求解!
job1 NUMBER;
BEGIN
dbms_job.submit(:job1 ,'Myproc;', SYSDATE,'sysdate+1/1440');
COMMIT;
END;
修改成如下即可:SQL code
DECLARE
job1 NUMBER;
BEGIN
dbms_job.submit(:job1 ,'Myproc;', SYSDATE,'sysdate+1/1440');
COMMIT;
END;
我Run了之后,报如下错误:
ORA-06550: 第 4 行, 第 67 列:
PLS-00103: Encountered the symbol "" when expecting one of the following: ( 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
求解!
declare
job1 number;
begin
sys.dbms_job.submit(job1, 'myproc;', sysdate, 'sysdate+1/1440');
commit;
end;
/
改成这样就可以了
dbms_job.submit(:job1 ,'Myproc;', SYSDATE,'sysdate+1/1440');
后面多了一个不知什么符,把它去掉就行了
SQL code
DECLARE
job1 NUMBER;
BEGIN
sys.dbms_job.submit(job1 ,'Myproc;', SYSDATE,'sysdate+1/1440');
COMMIT;
END;
/报如下错误
ORA-06550: line string, column string: string
Cause: Usually a PL/SQL compilation error.Action: None