Rem
Rem $Header: pp_db_schema_downgrade.sql 27-may-2008.15:02:15 chyu Exp $
Rem
Rem pp_db_schema_downgrade.sql
Rem
Rem Copyright (c) 2006, 2008, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      pp_db_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    chyu        01/23/07 - adding the dynamic logic
Rem    kvsingh     12/10/06 - 
Rem    gmanglik    11/29/06 - downgrade for pp_db schema
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_db_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_db/' ||  'pp_db_schema_downgrade' || '_' || '&CURR_VER' || '_' || '&PREV_VER' || '.sql';
     END IF;
END;
/
SELECT :script_name FROM DUAL;
@&pp_db_schema_downgrade