Oracle and PL/SQL Recipes: A Problem-Solution Approach

15-13. Removing a Java Class

Problem

You want to drop a Java class from your database.

Solution

Issue the SQL DROP JAVA command along with the schema and object name you want to drop. For instance, you want to drop the Java source for the Employees class. In this case, you would issue the following command:

DROP JAVA SOURCE “Employees”;

How It Works

There may come a time when you need to drop a Java class or sources from the database. For instance, if you no longer want to maintain or allow access to a particular Java class, it may make sense to drop it. The DROP JAVA SOURCE command does this by passing the name of the class or source as demonstrated within the solution to this recipe.

Note Be careful not to drop a Java class if other Java ...