Dropping Packages

Previous

Next

You can use the SQL DROP statement or the Object Browser page to drop packages and package bodies.

You can drop a package or package body with the SQL DROP statement. When drop a package specification, the corresponding package body is dropped also. You can choose to drop only the package body. For example:

-- drop only the package body
DROP PACKAGE BODY my_package;
-- drop the package specification and package body
DROP PACKAGE my_package;

To drop a package or package body with the Object Browser page:

1. Log in to the Database Home Page. See "Logging in to the Database Home Page". To run the examples in this guide, log in as user HR with your password for the HR account.

2. On the Database Home Page, click the Object Browser icon.

3. Select Packages in the object list, then click the package you want to display.

   The package specification information displays.

4. With the package specification displayed, click the Drop button to drop the package specification and package body. You can click the Body tab and then the Drop button to drop only the packaged body if it exists.

5. Click the Finish button to confirm that you want to drop the package specification or package body.