Rem
Rem $Header: pp_schema_downgrade.sql 27-may-2008.15:02:15 chyu Exp $
Rem
Rem pp_schema_downgrade.sql
Rem
Rem Copyright (c) 2006, 2008, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      pp_schema_downgrade.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    chyu        05/27/08 - using the normalized version with 5 digits
Rem    kvsingh     11/19/06 - Created
Rem

define CURR_VER                       = "&1"
define PREV_VER                       = "&2"

Rem Select downgrade script to run
Rem
COLUMN :script_name NEW_VALUE pp_schema_downgrade NOPRINT
VARIABLE script_name VARCHAR2(256)
BEGIN
     IF '&CURR_VER' = '0.0.0.0.0'  OR
        '&PREV_VER' = '0.0.0.0.0'
     THEN
        :script_name := '&EM_SQL_ROOT/core/latest/admin/admin_do_nothing.sql';
     ELSE
        :script_name := '&EM_SQL_ROOT/db/downgrade/pp/' ||  'pp_schema_downgrade' || '_' || '&CURR_VER' || '_' || '&PREV_VER' || '.sql';
     END IF;
     
     IF '&PREV_VER' = '0.0.0.0' THEN
      DELETE mgmt_versions where component_name = 'PP';
     END IF;
END;
/

SELECT :script_name FROM DUAL;
@&pp_schema_downgrade