Rem Copyright (c) 1995, 2010, Oracle and/or its affiliates. 
Rem All rights reserved. 
Rem
Rem   NAME
Rem     owacomm.sql - PL/SQL Gateway package installation
Rem   PURPOSE
Rem     Install the PL/SQL packages needed to run the PL/SQL
Rem     gateway for 8.x and beyond databases.
Rem   NOTES
Rem     This script installs the PL/SQL gateway toolkit 
Rem     packages (such as HTP/HTP/OWA_UTIL, WPG_DOCLOAD etc.)
Rem     it should be called BY a driver script such AS owaload.sql
Rem   IMPORTANT
Rem     Please keep this file as generic as possible. This file must be
Rem     able to run in both SQLPLUS and SVRMGRL
Rem   history
Rem     ehanks     01/18/08 -  Changing "grant all" to "grant execute" for
Rem                            security bug #6596784.
Rem     dnonkin    08/31/04 -  removed call to owadins.sql 
Rem     pkapasi    06/17/01 -  Add support for EBCDIC databases(bug#1778693)
Rem     ehlee      03/14/01 -  split handle 8.0.x databases to owacomm8.sql
Rem     ehlee      12/26/00 -  handle 8.0.x databases
Rem     rdecker    07/21/00 -  split synonym handling INTO NEW files
Rem     ehlee      05/05/00 -  fixing spelling error for "package"
Rem     ehlee      05/05/00 -  add owa_cache
Rem     rdecker    04/20/00 -  split off FROM owaload.sql
Rem

prompt In owacomm.sql
  
@@owachars.sql
@@pubcust.sql
@@pubht.sql
@@pubutil.sql
@@pubsec.sql
@@pubowa.sql
@@pubtext.sql
@@pubpat.sql
@@pubimg.sql
@@pubcook.sql
@@puboolk.sql
@@pubcach.sql
@@pubmat.sql
@@wpgdocs.sql
 
@@privcust.sql
@@privht.sql
@@privowa.sql
@@privutil.sql
@@privtext.sql
@@privpat.sql
@@privimg.sql
@@privcook.sql
@@privoolk.sql
@@privsec.sql
@@privcach.sql
@@privmat.sql
@@wpgdocb.sql

prompt Granting execute privs to public
grant execute on OWA_CUSTOM to public;
grant execute on OWA to public;
grant execute on HTF to public;
grant execute on HTP to public;
grant execute on OWA_COOKIE to public;
grant execute on OWA_IMAGE to public;
grant execute on OWA_OPT_LOCK to public;
grant execute on OWA_PATTERN to public;
grant execute on OWA_SEC to public;
grant execute on OWA_TEXT to public;
grant execute on OWA_UTIL to public;
grant execute on OWA_CACHE to public;
grant execute on OWA_MATCH to public;
grant execute on WPG_DOCLOAD to public;
prompt Done granting execute privs to public

REM CREATE PUBLIC owa synonyms
@@owacsyn