Plsql developer 工具创建存储过程，必须要在package 文件下创建存储声明 pa

Plsql developer 工具创建存储过程，必须要在package 文件下创建存储声明 pa

是的！
给一个例子给你
CREATE OR REPLACe PACKAGE PKG_USER AS
TYPE DEPT_TYPE IS TABLE OF DEPT%ROWTYPE;
PROCEDURE INSERTOPERATE(P_USERTYPE IN DEPT_TYPE);
END PKG_USER;

SELECT S.OBJECT_NAME,S.STATUS FROM ALL_OBJECTS S WHERe S.OBJECT_NAME=UPPER('Pkg_User');

CREATE OR REPLACE PACKAGE BODY PKG_USER IS
PROCEDURE INSERTOPERATE(P_USERTYPE IN DEPT_TYPE) IS
BEGIN
SAVEPOINT AA;
FOR I IN 1 .. P_USERTYPE.COUNT LOOP
INSERT INTO DEPT
(DEPTNO, DNAME, LOC)
VALUES
(P_USERTYPE(I).DEPTNO, P_USERTYPE(I).DNAME, P_USERTYPE(I).LOC);
END LOOP;
COMMIT;
EXCEPTION WHEN OTHERS THEN ROLLBACK TO AA;
END INSERTOPERATE;
END PKG_USER;

如以上回答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！

点此我要举报以上问答信息