建立一个job 调用p_clean_equip这个存储过程,但是定义job的时候出现下面的问题SQL> variable n number;
SQL>
SQL> begin
2 dbms_job.submit(n,'p_clean_equip;',sysdate,'sysdate+1');
3 end;
4 /
begin
dbms_job.submit(n,'p_clean_equip;',sysdate,'sysdate+1');
end;
ORA-06550: line 3, column 17:
PLS-00201: identifier 'N' must be declared
ORA-06550: line 3, column 1:
PL/SQL: Statement ignored在线等解答谢谢
SQL>
SQL> begin
2 dbms_job.submit(n,'p_clean_equip;',sysdate,'sysdate+1');
3 end;
4 /
begin
dbms_job.submit(n,'p_clean_equip;',sysdate,'sysdate+1');
end;
ORA-06550: line 3, column 17:
PLS-00201: identifier 'N' must be declared
ORA-06550: line 3, column 1:
PL/SQL: Statement ignored在线等解答谢谢
变量N没有声明,参考一下格式:DECLARE
X NUMBER;
BEGIN
SYS.DBMS_JOB.SUBMIT
( job => X
,what => 'p_t_sp_tenminutesstat;'
,next_date => to_date('20-01-2010 05:00:16','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;
/
------------------------------------------------------------------------------
Blog: http://blog.csdn.net/tianlesoftware
网上资源: http://tianlesoftware.download.csdn.net
相关视频:http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
Q Q 群:62697716
dbms_job.submit(:n,'p_clean_equip;',sysdate,'sysdate+1');
N NUMBER;
BEGIN
这样申明N