oracle 创建存储过程报错， PACKAGE BODY SCOTT.EMP_SAL_MANAGEMENT 编译错误
错误：PLS-00323: 子程序或游标 'P_P_BONUS' 已在程序包说明中声明, 必须在程序包体中对其进行定义。
行：2
文本：IS PROCEDURE P_Bonus(MASSAGE OUT VARCHAR2,
文本：IS PROCEDURE P_Bonus(MASSAGE OUT VARCHAR2,
CREATE OR REPLACE PACKAGE EMP_SAL_MANAGEMENT IS
PROCEDURE P_P_Bonus(MESSAGE OUT VARCHAR2,
ENPNO IN NUMBER,
COMM IN NUMBER);
END EMP_SAL_MANAGEMENT;
CREATE OR REPLACE PACKAGE BODY emp_sal_management
IS PROCEDURE P_Bonus(MASSAGE OUT VARCHAR2,
EMPNO IN NUMBER,
COMM IN NUMBER)
IS
BEGIN
MASSAGE:='OK';
UPDATE EMP SET COMM=COMM WHERE EMPNO=EMPNO;
EXCEPTION
WHEN OTHERS THEN
MASSAGE := sqlerrm;
rollback;
RETURN;
END P_Bonus;
end emp_sal_management;
最新回答
解桑陌
2024-06-25 00:27:10
一身懵逼正气
2024-06-25 00:11:37
热门标签
