James's Blog

Oracle: create package

CREATE or REPLACE PACKAGE test_actions AS
PROCEDURE add_entry(c1 number, c2 varchar2);
PROCEDURE del_entry(c1 number);
END test_actions;

CREATE or REPLACE PACKAGE BODY test_actions AS
PROCEDURE add_entry(c1 number, c2 varchar2);
BEGIN
INSERT INTO test2(c1,c2) VALUES(c1,c2);
END add_entry;
PROCEDURE del_entry(c1 number)
BEGIN
DELETE FROM test2 WHERE c1 = c1;
END del_entry;
END test_actions;

posted by James Pei @ 3:29 PM