SQL报错 ORA-00900

11 |

1 | 2010-6-11 12:46:24 | 显示全部楼层 |阅读模式

执行下面语句报错ORA-00900:inbalid SQL statement，请教一下哪里问题？
VARIABLE JOBNO NUMBER;
VARIABLE INSTNO NUMBER;
BEGIN
SELECT INSTANCE_NUMBER INTO :INSTNO FROM V$INSTANCE;
DBMS_JOB.SUBMIT(:JOBNO,'ANALYZE_TB;',TRUNC(SYSDATE)+1+2/24,'TRUNC(SYSDATE)+2+2/24',TRUE,:INSTNO);
COMMIT;
END;

使用道具举报