1、创建包
--创建一个包
--声明三个存储过程
CREATE OR REPLACE PACKAGE JLWHANG_PACKAGE IS
PROCEDURE JL_PRO;
PROCEDURE JL_PRO2;
PROCEDURE JL_PRO3(MYNAME VARCHAR2, NEWSAL NUMBER);
END;
1、创建包体
CREATE OR REPLACE PACKAGE BODY JLWHANGH_PACKAGE IS
PROCEDURE jl_pro IS
BEGIN
INSERT INTO mytest values('user1','pass1');
END;
procedure jl_pro2 IS
BEGIN
--执行部分
DELETE FROM mytest WHERE NAME='user1';
END;
PROCEDURE jl_pro3(myname varchar2,newsal NUMBER) IS
BEGIN
UPDATE emp SET sal=newsal WHERE ename=myname;
COMMIT;
END;
END;
--创建一个包
--声明三个存储过程
CREATE OR REPLACE PACKAGE JLWHANG_PACKAGE IS
PROCEDURE JL_PRO;
PROCEDURE JL_PRO2;
PROCEDURE JL_PRO3(MYNAME VARCHAR2, NEWSAL NUMBER);
END;
1、创建包体
CREATE OR REPLACE PACKAGE BODY JLWHANGH_PACKAGE IS
PROCEDURE jl_pro IS
BEGIN
INSERT INTO mytest values('user1','pass1');
END;
procedure jl_pro2 IS
BEGIN
--执行部分
DELETE FROM mytest WHERE NAME='user1';
END;
PROCEDURE jl_pro3(myname varchar2,newsal NUMBER) IS
BEGIN
UPDATE emp SET sal=newsal WHERE ename=myname;
COMMIT;
END;
END;