DECLARE
X NUMBER;
BEGIN
SYS.DBMS_JOB.SUBMIT
( job => 1000 //此句不行
,what => 'DBP_ClearMessDate;'
,next_date => to_date('23-08-2010 03:00:00','dd/mm/yyyy hh24:mi:ss')
,interval => 'SYSDATE + 1'
,no_parse => FALSE
);
SYS.DBMS_OUTPUT.PUT_LINE('Job Number is: ' || to_char(x));
COMMIT;
END;
/
X NUMBER;
BEGIN
SYS.DBMS_JOB.SUBMIT
( job => 1000 //此句不行
,what => 'DBP_ClearMessDate;'
,next_date => to_date('23-08-2010 03:00:00','dd/mm/yyyy hh24:mi:ss')
,interval => 'SYSDATE + 1'
,no_parse => FALSE
);
SYS.DBMS_OUTPUT.PUT_LINE('Job Number is: ' || to_char(x));
COMMIT;
END;
/
JOBID是一个out型参数,你当然不能指定传入
SQL> desc dbms_job.submit
Parameter Type Mode Default?
--------- -------------- ---- --------
JOB BINARY_INTEGER OUT
WHAT VARCHAR2 IN
NEXT_DATE DATE IN Y
INTERVAL VARCHAR2 IN Y
NO_PARSE BOOLEAN IN Y
INSTANCE BINARY_INTEGER IN Y
FORCE BOOLEAN IN Y
SQL>