-------------------------------------------------------------------------------
--
--  @Copyright (c) 2002, Oracle Corporation. All rights reserved.
--  @headcom
--
--  Installs the database services provider & portlet.
--
--  This file is used to install the services provider
--  package and the packages of the portlets it implements.
--
--  Note:  If the schema where this provider is installed
--  is not the portal schema then the provsyns.sql script
--  needs to be run prior to running this script.  
--  The provsyns.sql script is in the wwc directory.  
--  Instructions of how to run the provsyns.sql
--  script is included in the script.
--
--  After this script is successfully run the script
--  services_register.sql needs to run in the portal
--  schema in order to register the provider with
--  the portal.  Alternatively, the provider may be
--  registered from the portal UI.
--
--  @param 1 The schema associated with the provider.
--
--  @usage   Login to sqlplus as the provider schema owner and type:
--           @services_install.sql <portal_schema>
--
--  @example sqlplus prov/prov@mydatabase portal
--
--  @scope   Public
--  @rerun
--
-------------------------------------------------------------------------------

set serveroutput on size 1000000
set define on

@@services_provider.pks
@@services_portlet.pks
@@services_provider.pkb
@@services_portlet.pkb &&1

grant execute on services_portlet to public;

