Rem
Rem This file is used to install the Flights of Fancy
Rem application including the Flights of Fancy provider
Rem and flights overview portlet.
Rem
Rem Usage:  login to sqlplus as the application schema owner
Rem (e.g. provs/provs)
Rem In sqlplus type the following:
Rem @flinstal.sql <listener_server> <listener_port> <dad> <provider_schema>
Rem where
Rem <listener_server> the machine where the apache server is running on
Rem <listener_port> the port used by apache
Rem <dad> the dad used to access this application
Rem <provider_schema> the schema where this application resides
Rem
Rem Note: The provsyns.sql script should be run prior to 
Rem 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
Rem After this script was successfully run the script
Rem flights_register.sql needs to run in the portal
Rem schema in order to register the provider with
Rem the portal.  Alternatively, the provider may be
Rem registered from the portal UI.

set serveroutput on size 1000000
set define on

@@flsec.pks
@@flsec.pkb


@@flapppro.pks
@@flappptl.pks
@@flapp.pks
@@flapppro.pkb
@@flappptl.pkb
@@flapp.pkb

grant execute on flights_of_fancy to public;
