I have a package that contains one procedure; how do I add another procedure to the package?
CREATE OR REPLACE PACKAGE fubar
AS
PROCEDURE insert_MyYempTable
(
sUserID IN VARCHAR2
, in_Location IN VARCHAR2
)
;
END fubar;
CREATE OR REPLACE PACKAGE BODY fubar
AS
PROCEDURE insert_MyTempTable
(
sUserID IN VARCHAR2
, in_Location IN VARCHAR2
)
IS
BEGIN
INSERT INTO MyTempTable(City, State, Zip)
SELECT city, state, zip
From MyTable1
WHERE UserID = sUserID
commit;
END insert_MyTempTable;