Rem
Rem $Header: sdo/admin/sdoe112.sql /st_sdo_11.2.0/1 2010/05/03 10:31:24 sravada Exp $
Rem
Rem sdoe112.sql
Rem
Rem Copyright (c) 2010, Oracle and/or its affiliates. All rights reserved. 
Rem
Rem    NAME
Rem      sdoe112.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     05/03/10 - Created
Rem

SET ECHO ON
SET FEEDBACK 1
SET NUMWIDTH 10
SET LINESIZE 80
SET TRIMSPOOL ON
SET TAB OFF
SET PAGESIZE 100

ALTER SESSION SET CURRENT_SCHEMA = MDSYS;

EXECUTE dbms_registry.downgrading('SDO');

@@seme112.sql


ALTER SESSION SET CURRENT_SCHEMA = MDSYS;
SET ECHO ON;


-- Downgrade Locator stuff first
@@loce112.sql


ALTER SESSION SET CURRENT_SCHEMA = MDSYS;


DECLARE
  stmt varchar2(100);
BEGIN
 BEGIN
  stmt :=
  'alter table MDSYS.WFS_CapabilitiesInfo$ drop (WFS_VERSION)';
  execute immediate stmt;
    exception when others then null;
 END;

 BEGIN
  stmt :=
  'alter table MDSYS.WFS_FeatureType$ drop (WFS_VERSION)';
  execute immediate stmt;
    exception when others then null;
 END;
END;
/
SHOW ERRORS;


ALTER SESSION SET CURRENT_SCHEMA = SYS;

EXECUTE dbms_registry.downgraded('SDO', '11.2.0');