--创建存储过程
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.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
BEGIN
DBMS_OUTPUT.PUT_LINE(SYSDATE);
END;