Uninstalling Parsers

Removing XML Parser from the Database

Question

I am deinstalling a version of XML Parser and installing a newer version. How do I do that? I know that there is something like dropjava , but still there are other packages which are loaded into the schema. I want to clean out the earlier version and install the new version in a clean manner.

Answer

You'll need to write SQL to write SQLbased on the USER_OBJECTS table where:

SELECT 'drop java class '''| |       dbms_java.longname(object_
name)| |''';

from user_objects where

OBJECT_TYPE = 'JAVA CLASS'and DBMS_JAVA.LONGNAME(OBJECT_NAME)     LIKE 
'oracle/xml/parser/%'

This will spew out a set of DROP JAVA CLASS command which you can capture in a file using SQL*Plus': SPOOL somefilenamecommand.

Then run that spool file as a SQL script and all the right classeswill be dropped.