Rem
Rem $Header: sdo/admin/sdounloadj.sql /st_sdo_11.2.0/1 2010/09/29 14:38:34 sravada Exp $
Rem
Rem sdounloadj.sql
Rem
Rem Copyright (c) 2007, 2010, Oracle and/or its affiliates. 
Rem All rights reserved. 
Rem
Rem    NAME
Rem      sdounloadj.sql - <one-line expansion of the name>
Rem
Rem    DESCRIPTION
Rem      <short description of component this file declares/defines>
Rem
Rem    NOTES
Rem      <other useful comments, qualifications, etc.>
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    sravada     09/29/10 - bug 10119184
Rem    alwu        02/22/08 - comment out dropjava for sdordf.jar
Rem    sravada     05/13/07 - Created
Rem


ALTER SESSION SET CURRENT_SCHEMA = SYS;

-- drop sdonm.jar
call dbms_java.grant_permission('SYSTEM', 'java.io.FilePermission',
                                 '<<ALL FILES>>', 'read');
call dbms_java.grant_permission('MDSYS', 'SYS:java.io.FilePermission',
                                'md/jlib/*', 'read');
call dbms_java.grant_permission('MDSYS', 'SYS:java.lang.RuntimePermission',
                                'getClassLoader', null);
call dbms_java.grant_permission('ORDSYS', 'SYS:java.lang.RuntimePermission',
                                'getClassLoader', null);


call dbms_java.dropjava('-force -synonym -schema MDSYS md/jlib/sdonm.jar');
call dbms_java.dropjava('-force -synonym -schema MDSYS md/jlib/sdoapi.jar');
call dbms_java.dropjava('-force -synonym -schema MDSYS md/jlib/sdotopo.jar');
call dbms_java.dropjava('-force -synonym -schema MDSYS md/jlib/sdoutl.jar');
call dbms_java.dropjava('-force -synonym -schema MDSYS md/jlib/sdogr.jar');
call dbms_java.dropjava('-force -synonym -schema MDSYS md/jlib/sdogcdr.jar');
call dbms_java.dropjava('-force -synonym -schema MDSYS md/jlib/routepartition.jar');
-- drop sdotype.jar
call dbms_java.dropjava('-force -synonym -schema MDSYS md/jlib/sdotype.jar');

-- 10.2 version
declare
 stmt varchar2(400);
 javac varchar2(300);
  type                    cursor_type is REF CURSOR;
 query_crs               cursor_type ;
begin

  stmt := ' select NAME from all_java_classes ' ||
          ' where owner=''MDSYS'' ';
   OPEN query_crs FOR stmt;
  LOOP
  BEGIN
    fetch query_crs into  javac;
    EXIT when query_crs%NOTFOUND ;
    javac := SYS.DBMS_ASSERT.ENQUOTE_NAME(javac,false);
    begin
     EXECUTE immediate ' drop java class MDSYS.'||javac;
    EXCEPTION
     WHEN OTHERS THEN
      NULL;
    end;
  end;
  END LOOP;
  close query_crs;
end;
/


-- drop RDF jar. 
-- Seems that this script is only invoked as part of loce111.sql 
-- RDF/OWL cannot drop this jar because if this jar is dropped, then in the
-- case that downgrade is followed by upgrade, we no longer have this jar.
-- call dbms_java.dropjava('-force -synonym -schema MDSYS md/jlib/sdordf.jar');

call dbms_java.revoke_permission('MDSYS','SYS:java.io.FilePermission',
                                 'md/jlib/*','read');