CREATE OR REPLACE PACKAGE employee2 AS
PROCEDURE proce(f_name varchar2, l_name varchar2);
END;
CREATE OR REPLACE PACKAGE BODY employee2 AS
PROCEDURE proce(f_name varchar2, l_name varchar2) IS
BEGIN
INSERT INTO emp2(f_name, l_name) VALUES(f_name, l_name);
END;
END employee2;
BEGIN
employee2.proce('bat', 'man');
END;
this code runs correctly and bat man get inserted to the table which i created.
but when it comes to dropping the package
DROP PACKAGE employee2;
it throws the following error;
SQL Error [933] [42000]: ORA-00933: SQL command not properly ended
help me out with this