Dropping Standalone Stored Subprograms

To drop a standalone stored subprogram, use either the SQL Developer navigation frame and Drop tool, or the DDL statement DROP PROCEDURE or DROP FUNCTION.

To drop a standalone stored subprogram using the Drop tool:

1. On the Connections tab, expand hr_conn.

   Under the hr_conn icon, a list of schema object types appears.

2. Expand either Functions or Procedures.

   A list of functions or procedures appears.

3. Right-click the name of the function or procedure to drop.

   A list of choices appears.

4. Click Drop.

   The Drop window opens.

5. Click Apply.

   The Confirmation window opens.

6. Click OK.