Rem  Copyright (c) 1995, 1996, 1997 by Oracle Corp.  All Rights Reserved.
Rem
Rem   NAME
Rem     owaload.sql - PL/SQL Gateway package installation
Rem   PURPOSE
Rem     Install the PL/SQL packages needed to run the PL/SQL
Rem     gateway.
Rem   NOTES
Rem     This driver script installs the PL/SQL gateway toolkit 
Rem     packages (such as HTP/HTP/OWA_UTIL, WPG_DOCLOAD etc.)
Rem     as well as other internal packages needed by the 
Rem     PL/SQL gateway.
Rem   HISTORY
Rem     rdecker    07/07/00 -  owacommon -> owacomm
Rem     ehlee      05/05/00 -  Install whole OWA package as SYS; add owa_cache
Rem     rdecker    04/20/00 -  USE owacommon.sql
Rem     kmuthukk   04/19/00 -  updates for new PL/SQL gateway
Rem     mpal       11/06/97 -  Add @
Rem     rdasarat   10/17/97 -  create public synonym owa_init for owa_custom
Rem     mpal       07/09/97 -  Implementing CUSTOM scheme, COMMON schema
Rem     mpal       05/08/97 -  Modified to reflect dbms_sys_sql changes
Rem     mpal       12/06/96 -  Creation
Rem
Rem

whenever oserror exit 32767
set define on
spool &&1

Rem
Rem first, when we are connect as SYS, create
Rem the wpiutl describe package in SYS.
Rem
drop package sys.wpiutl;
@@wpiutl.sql

set define off
  
Rem call owacomm.sql TO load ALL OF the common owa/gateway packages  
@@owacomm.sql
  
spool off

exit

