Rem
Rem This file is used to install the cache provider
Rem package and the packages of the portlets it implements.
Rem
Rem Usage:  login to sqlplus as the provider schema owner
Rem (e.g. provs/provs)
Rem In sqlplus type the following:
Rem @insintpr.sql
Rem
Rem Note:  If the schema where this provider is installed
Rem is not the portal schema then the provsyns.sql script
Rem needs to be run prior to running this script.  
Rem The provsyns.sql script is in the wwc directory.  
Rem Instructions of how to run the provsyns.sql
Rem script is included in the script.
Rem

set define off

@@cache_provider.pks
@@validcache_portlet.pks
@@expirycache_portlet.pks
@@invalidcache_portlet.pks
@@inv_validcache_portlet.pks
@@cache_provider.pkb
@@validcache_portlet.pkb
@@expirycache_portlet.pkb
@@invalidcache_portlet.pkb
@@inv_validcache_portlet.pkb

grant execute on INVALIDCACHE_PORTLET to PUBLIC
/

grant execute on INVALID_VALID_CACHE_PORTLET to PUBLIC
/

