执行存储过程失败了,菜鸟不清楚哪里出问题了,求大神
--创建存储过程
CREATE OR REPLACE PROCEDURE out_time
IS
BEGIN
DBMS_OUTPUT.PUTLINE(SYSDATE);
END;
--编译一下
ALTER PROCEDURE out_time Compile
--执行出错了
BEGIN
out_time;
END;
出错信息:
ORA-06550: line 2, column 5:
PLS-00905: object MASHEC.OUT_TIME is invalid
ORA-06550: line 2, column 5:
PL/SQL: Statement ignored
------解决方案--------------------CREATE OR REPLACE PROCEDURE OUT_TIME IS
BEGIN
DBMS_OUTPUT.PUT_LINE(SYSDATE);
END;