本文共 1414 字，大约阅读时间需要 4 分钟。
? Oracle ???????DBMS_JOB.SUBMIT ????????????????????????Job????????????????????????????????????????????????????
??????? DBMS_JOB.SUBMIT ??????
declare jobnum number;begin dbms_job.submit( jobnum, 'Pro1', sysdate, 'last_day(sysdate) + 1', true );end;
??????????? Pro1 ????????????????????????sysdate ?????????? last_day(sysdate) ????????????
??????????????????
ORA-12011: ????
DBMS_JOB ????????????????????ORA-06550: ??????
PLS-00103: ????
?????????????????????????????? alert.log ????????????
Errors in file d:\oracle\product\10.2.0\admin\gcms\udump\gcms_ora_4012.trc:ORA-12012: 86ORA-06550: 1 110 : PLS-00103: "" := . ( @ % ;";;" ORA-06550: 1 1 : PLS-00103: "" := . ( @ % ;";
??????????????????????????????????????????????????????????
??????????????????????????
?????????????????? DBMS_JOB ????????????
????????????? ('Pro1' ?) ?????????????
?????????????????????????????????
???????????????????????????
declare jobnum number;begin dbms_job.submit( jobnum, 'Pro1;', sysdate, 'last_day(sysdate) + 1', true );end;
?????????????? DBMS_JOB.SUBMIT ?????????????????????????????????????????????????????????????????????????????
转载地址：http://lppfk.baihongyu.com/