Instructions for installing the Flights of Fancy application.

----------------------------------------------------------------------
Step 1
----------------------------------------------------------------------
Create a schema (provider schema) where the partner application packages will be installed.
In this schema the provider and portlets implemented for the application
are also installed.

----------------------------------------------------------------------
Step 2
----------------------------------------------------------------------
Enable the provider schema created at step 1 to be used as a provider schema and
as partner application schema.  This involves the following 2 tasks


Perform the required setup required by the login server SDK. This is detailed in 
in the Install.txt in the SDK.

This includes:
- Loading the PL/SQL crypto packages and the OWA packages if not already loaded
in your database.
- Create your Partner Provider schema.
- Loading SSOHash.class using loadjava for the Partner schema you created.
- Running loadsdk.sql in the Partner schema you created.
- Adding your new Partner Application through the Portal UI. This is where
  you register the Flights of Fancy Partner Application with the Login Server.

   You can do this by logging into Oracle Portal, clicking on the Administer tab, 
   and choosing the Login Server Administration link.  You can then administer 
   Partner Applications to add a new Partner Application.  
   Choose an application name for your Partner Application.  
   Note the Application name you choose, for use later on. For the Home URL, 
   you can choose to use the Portal Home URL  since this will be invoked if you 
   press 'Cancel' while logging in with the Login Server.  For the Success URL, 
   you need to invoke the process_success procedure of the flights_of_fancy package. 
   So the URL will be of the following format:
   http://<Web Server>:<Port>/pls/<DAD>/<Partner Provider Schema>.flights_of_fancy.process_success.

- Editing and running the regapp.sql script as directed.
  (You need to give <Application name>:<Complete web server host name>:<Port>
   for your Listener token.)


----------------------------------------------------------------------
Step 3
----------------------------------------------------------------------
Task A - Run the provsyns.sql script for the provider schema.  This file exists
in the wwc directory.  Instructions in running this script exist inside the script.

Task B - In sqlplus, in the PROVIDER schema, run:
flinstal.sql <listener_server> <port> <dad> <provider_schema> <application_name>
e.g.
SQLPLUS> @flinstal.sql webdbsvr.us.oracle.com 3000 portal_dad partner_flights flights_of_fancy 


----------------------------------------------------------------------
Step 4
----------------------------------------------------------------------
In sqlplus, in the PORTAL schema, run: 
flreg.sql <portal_schema> <provider_schema>

----------------------------------------------------------------------
Step 5
----------------------------------------------------------------------
The main screen for accessing the partner application is:
http://<listener_server>:<port>/pls/<dad>/<provider_schema>.flights_of_fancy.show_flights

The flappdb.html provides more details about this application.