Question

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

Plsql developer 工具创建存储过程，必须要在package 文件下创建存储声明 package bodies目录下创建具体实现方式吗

• 你的回答被采纳后将获得：
• 系统奖励15（财富值+成长值）+难题奖励20（财富值+成长值）

Answer 1

是的！
给一个例子给你
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;