创建的过程带有编译错误是什么问题？

jerryzheng

本人用scott帐号连接sqlplus 然后写了以下一个简单的存储过程：
CREATE OR REPLACE PROCEDURE COUNT_JOB_HISTORY
(
   reccount OUT NUMBER
)
IS
BEGIN
   SELECT COUNT(*) INTO reccount
   FROM JOB_HISTORY;
END COUNT_JOB_HISTORY;

然后提交的时候告诉我“警告: 创建的过程带有编译错误”怎么解决

binary

SQL>; show error

看看提示什么错，应该是JOB_HISTORY表不存在吧

rollingpig

show errors

show errors procedure scott.COUNT_JOB_HISTORY