Dropping a Package
Creating and Using Packages
4-14 Oracle Database 2 Day Developer's Guide
CREATE OR REPLACE
PACKAGE BODY emp_eval AS
PROCEDURE eval_department(department_id IN NUMBER) AS
BEGIN
/* TODO implementation required */
NULL;
END eval_department;
FUNCTION calculate_score(evaluation_id IN NUMBER
, performance_id IN NUMBER)
RETURN NUMBER AS
BEGIN
/* TODO implementation required */
RETURN NULL;
END calculate_score;
END emp_eval;
4.
Compile and save the package body.
You will see the following message that confirms that the package body compiled
correctly.
EMP_EVAL Body Compiled.
Dropping a Package
You can delete a package from the database either by using the Connections navigator
hierarchy or the SQL
DROP
statement. When you drop a package, you remove from the
database both the package specification and its package body.
To drop a package:
1.
In the Connections navigator hierarchy, select Packages, and then right-click the
EVAL
package.
2.
Select Drop Package.
See Also:
Oracle Database SQL Language Reference for information on the
CREATE PACKAGE BODY
statement
Oracle Database SQL Language Reference for information on the
ALTER PACKAGE
statement
