-- In-place Design Repository Upgrade to OWB 10.2.0.2.0 ...

ACCEPT V_HOST PROMPT 'Host Name: '
ACCEPT V_PORT PROMPT 'Port Number: '
ACCEPT V_SERVICENAME PROMPT 'Service Name: '
ACCEPT V_USER_NAME PROMPT 'Existing OWB Repository Owner Username: '
ACCEPT V_USER_PASSWORD PROMPT 'Existing OWB Repository Owner Password: ' HIDE
ACCEPT V_MODE PROMPT 'Enter execution mode (0 = Report only / 1 = Report and Fix) : '
PROMPT 
PROMPT Review above entries and press
ACCEPT V_DUMMY PROMPT ' <ENTER> to continue or Ctrl-C to cancel'

set serveroutput on
set serveroutput on size 100000

SPOOL LOG.TXT

PROMPT Connect to Design repository user ...
WHENEVER SQLERROR EXIT FAILURE
connect &V_USER_NAME/&V_USER_PASSWORD@(DESCRIPTION=(ADDRESS=(HOST= &V_HOST )(PROTOCOL=tcp)(PORT= &V_PORT ))(CONNECT_DATA=(SERVICE_NAME= &V_SERVICENAME )))
WHENEVER SQLERROR CONTINUE

PROMPT Load the packages
drop package Bug5416660_FixProcessFlows;
@bug5416660.pks
@bug5416660.pkb

PROMPT Execute the fix.
exec Bug5416660_FixProcessFlows.FixProcessFlows(&V_MODE); 

PROMPT End of the upgrade.
SPOOL OFF
exit