Rem
Rem
Rem catpatch.sql
Rem
Rem Copyright (c) 2004,2009, Oracle Corporation.  All rights reserved.
Rem
Rem    NAME
Rem      catpatch.sql - Application Express 3.2.1 Patch Installation
Rem
Rem
Rem
Rem    MODIFIED   (MM/DD/YYYY)
Rem     jkallman   03/02/2009 - Created
Rem

spool apxpatch.log

set define '^'
define PREFIX     = '?/apex/'

timing start "Complete Patch"

@?/apex/patches/3.2.1/corepatch.sql

alter session set current_schema = SYS;

column :HOME new_value OH_HOME NOPRINT
variable HOME varchar2(255)

begin
-- get oracle_home
   dbms_system.get_env('ORACLE_HOME',:HOME);
end;
/

select :HOME from dual;

set define '&'

whenever sqlerror continue

@?/apex/patches/3.2.1/apxldimg.sql &OH_HOME/apex

timing stop