Rem drv: <migrate type="schema_upgrade" version="10.2.0.4" />
Rem
Rem $Header: portlet_schema_upgrade.sql 30-apr-2007.09:51:51 dgiaimo Exp $
Rem
Rem portlet_schema_upgrade.sql
Rem
Rem Copyright (c) 2007, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      portlet_schema_upgrade.sql - <one-line expansion of the name>
Rem
Rem    DESCRIPTION
Rem      Remove repository artifacts from removed 10.1.0.4 portlets feature.
Rem      The repository being upgraded may or may not have these
Rem      artifacts so the drop must handle exceptions raised and ignore them.
Rem
Rem
Rem    NOTES
Rem      <other useful comments, qualifications, etc.>
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    dgiaimo     04/30/07 - Changing 10.2.4.0 to 10.2.0.4
Rem    lgloyd      02/23/07 - remove obsolete portlet artifacts on schema
Rem                           upgrade
Rem    lgloyd      02/23/07 - remove traces of deprecated portlet feature
Rem

DECLARE
BEGIN

  BEGIN
    EXECUTE IMMEDIATE 'DROP PACKAGE BODY EM_PORTLETS_MONITORING';
  EXCEPTION
  WHEN OTHERS
  THEN
    NULL;
  END;

  BEGIN
    EXECUTE IMMEDIATE 'DROP PACKAGE EM_PORTLETS_MONITORING';
  EXCEPTION
  WHEN OTHERS
  THEN
    NULL;
  END;

  BEGIN
    EXECUTE IMMEDIATE 'DROP INDEX MGMT_PORTLET_SEARCH_IDX';
  EXCEPTION
  WHEN OTHERS
  THEN
    NULL;
  END;

  BEGIN
    EXECUTE IMMEDIATE 'DROP INDEX MGMT_PORTLET_DEF_IDX';
  EXCEPTION
  WHEN OTHERS
  THEN
    NULL;
  END;

  BEGIN
    EXECUTE IMMEDIATE 'DROP INDEX MGMT_PORTLET_PREFERENCE_PK';
  EXCEPTION
  WHEN OTHERS
  THEN
    NULL;
  END;

  BEGIN
    EXECUTE IMMEDIATE 'DROP TABLE MGMT_PORTLET_PREFERENCE_STORE';
  EXCEPTION
  WHEN OTHERS
  THEN
    NULL;
  END;

  BEGIN
    EXECUTE IMMEDIATE 'DROP TYPE MGMT_PTLT_GUID_ARRAY';
  EXCEPTION
  WHEN OTHERS
  THEN
    NULL;
  END;

  BEGIN
    EXECUTE IMMEDIATE 'DROP TYPE MGMT_PTLT_RAW_GUID_ARRAY';
  EXCEPTION
  WHEN OTHERS
  THEN
    NULL;
  END;

END;
/