rem --------------------------------------------------------------------------
rem File:        $RCSfile: robinst.sql $
rem Author:      $Author: pcsmith $
rem Date:        $Date: 2002/08/07 11:38:11 $
rem Version:     $Revision: 1.1 $
rem Status:      $State: Exp $
rem Locked_by:   $Locker:  $
rem Description: <Enter global description here>
rem Notes:       <Global notes>
rem RealAuth:    <Full real name of code author>
rem IncepDate:   <nnth Xxxember 1999>
rem Copyright:   (c) Oracle Corporation 1999.  All Rights Reserved.
rem --------------------------------------------------------------------------
rem Log of Changes from RCS
rem --------------------------------------------------------------------------
rem $Log: robinst.sql $
rem Revision 1.1  2002/08/07 11:38:11  pcsmith
rem Initial revision
rem
rem --------------------------------------------------------------------------
rem  
prompt
-- ODWA installation script
--
-- Run as ODWA Owner. 
--
-- Date         Version Who             What
-- 19 Mar 2001  4.3     Lucas Jellema   Added table create statement for ODWA_PROVIDED
-- 19 Mar 2001  4.2     Lucas Jellema   Add table ODWA_PROVIDED )odwa_pvd.tab)
-- 06 Mar 2001  4.1     Lucas Jellema   Add odwadeps.pks and odwadeps.pkb
-- 22 Jan 2001  4.0     Lucas Jellema   All new packages and tables in 6.5.0.7 Release
-- 22 Sep 2000  3.8     Lucas Jellema   $%NOTES::                                           $
-- 22 Sep 2000  3.7     Lucas Jellema   Do not install bodies for odwa_stc and odwa_wsf
-- 18 Sep 2000  3.3     Lucas Jellema   Add ODWADTLS, remove some unneeded objects
-- 15 Sep 2000  3.2     Lucas Jellema   All Echo Objects are out; cdwp_pal and cdwp_brw are out; all BL packages are out
-- 13 Aug 2000  3.1     Lucas Jellema   More changes for 6i
-- 02 Aug 2000  3.0     Lucas Jellema   First changes for 6i
-- 20 Jun 2000  2.9     Lucas Jellema   Added cdwp_bre.fnc
-- 19 Jun 2000  2.8     Lucas Jellema   Added cdwp_mco.pks and .pkb
-- 10 Jun 2000  2.7     Lucas Jellema   Changed order of CDWP and CDWPBASE specifications (since CDWP relies on CDWPBASE)
-- 08 Jun 2000  2.6     Lucas Jellema   Added call to odwa_rel.fnc
-- 08 Jun 2000  2.5     Lucas Jellema   Added calls to odwatree.pks and odwatree.pkb
-- 31 May 2000  2.4     Lucas Jellema   Added call to odwahtml.tab
-- 29 May 2000  2.3     Lucas Jellema   Changed cdwp_brf.prc to cdwp_brf.fnc
-- 28 May 2000  2.2     Lucas Jellema   Added ODWADBUG.pks and ODWADBUG.pkb
-- 27 May 2000  2.1     Lucas Jellema   ECHOMTCH.opb is now ODWAMTCH.opb; added ODWAPECY.opb
-- 26 May 2000  2.0     Lucas Jellema   Prepared for Production Release; added: cdwp_brd.fnc, odwa_mgt
--                                      Replaced @@ with @&&ODWA_HOME\ddl\
-- 23 May 2000  1.3     Sandra Muller   Added blmti
-- 22 May 2000  1.2     Ton van Kooten  Added blplm, blgem, bllan
-- 22 May 2000  1.1     Ton van Kooten  Added echo_arc.opb
-- 04 May 2000  1.0     Sandra Muller   Initial
--
set termout on
prompt Installing Oracle Designer Web Assistant (ODWA) database objects...
prompt
prompt ... installing ODWA tables/sequences and initial data
set termout off
-- 4.0
@..\ddl\odwa_him.tab
@..\ddl\odwa_hnd.tab
@..\ddl\odwa_htt.tab
@..\ddl\odwa_prf.tab
@..\ddl\odwadtls.tab
@..\ddl\odwagrph.tab
@..\ddl\odwasess.tab
@..\ddl\odwabrnc.tab
@..\ddl\odwahtml.tab
@..\ddl\odwa_elt.tab
@..\ddl\odwa_qck.tab

set termout on
-- 4.3
CREATE TABLE odwa_provided
( nm_irid number(38)
, CONSTRAINT odwa_pvd_pk PRIMARY KEY (nm_irid) 
)
ORGANIZATION INDEX 
/

prompt
prompt ... creating ODWA views
prompt
prompt ... creating general packages/procedures/functions
set termout off
@..\ddl\cdwp_brf.fnc
@..\ddl\cdwp_cev.fnc
@..\ddl\cdwp_brd.fnc
@..\ddl\odwa_rel.fnc
-- 2.9
@..\ddl\cdwp_bre.fnc
@..\ddl\hws.pck
set termout on
prompt
prompt ... creating ODWA package specifications
set termout off
set define off
@..\ddl\odwactxt.pks
@..\ddl\cdwpbase.pks
@..\ddl\cdwp.pks
@..\ddl\cdwp_br.pks
@..\ddl\cdwp_brd.pks
@..\ddl\odwadbug.pks
@..\ddl\cdwp_dia.pks
@..\ddl\cdwp_dom.pks
@..\ddl\cdwp_ent.pks
@..\ddl\cdwp_fun.pks
@..\ddl\cdwp_mde.pks
@..\ddl\cdwp_mco.pks
@..\ddl\cdwp_plm.pks
@..\ddl\cdwp_prc.pks
@..\ddl\cdwp_tbl.pks
@..\ddl\cdwp_ter.pks
@..\ddl\cdwp_txt.pks
@..\ddl\cdwp_vw.pks
@..\ddl\odwa_qck.pks
@..\ddl\odwa_stc.pks
@..\ddl\odwa_mgt.pks
@..\ddl\odwa_wsf.pks
-- 3.0
@..\ddl\odwatree.pks
@..\ddl\odwavrsn.pks
@..\ddl\cdwp_fil.pks
@..\ddl\odwarprt.pks
@..\ddl\odwa_fol.pks
@..\ddl\odwa_app.pks
@..\ddl\odwaxist.pks
-- 3.1
@..\ddl\odwalpad.pks
@..\ddl\odwasrch.pks
@..\ddl\odwaprop.pks
@..\ddl\odwaspot.pks
@..\ddl\odwagrph.pks
@..\ddl\odwarobs.pks
@..\ddl\odwabrow.pks
@..\ddl\odwainfo.pks

-- 4.0
@..\ddl\htmltree.pks
@..\ddl\odwachck.pks
@..\ddl\odwachki.pks
@..\ddl\odwaupld.pks
@..\ddl\odwapriv.pks
@..\ddl\odwapred.pks
@..\ddl\odwahelp.pks
@..\ddl\odwapref.pks
-- 4.1
@..\ddl\odwadeps.pks

set termout on
prompt ... creating ODWA package bodies
set termout off
@..\ddl\odwapref.pkb
@..\ddl\cdwp.pkb
@..\ddl\cdwpbase.pkb
@..\ddl\cdwp_br.pkb
@..\ddl\cdwp_brd.pkb
@..\ddl\odwadbug.pkb
@..\ddl\cdwp_dia.pkb
@..\ddl\cdwp_dom.pkb
@..\ddl\cdwp_ent.pkb
@..\ddl\cdwp_fun.pkb
@..\ddl\cdwp_mde.pkb
@..\ddl\cdwp_mco.pkb
@..\ddl\cdwp_plm.pkb
@..\ddl\cdwp_prc.pkb
@..\ddl\cdwp_tbl.pkb
@..\ddl\cdwp_ter.pkb
@..\ddl\cdwp_txt.pkb
@..\ddl\cdwp_vw.pkb
@..\ddl\odwa_qck.pkb
-- 3.6 @..\ddl\odwa_stc.pkb
@..\ddl\odwa_mgt.pkb
-- 3.6 @..\ddl\odwa_wsf.pkb
@..\ddl\odwatree.pkb
-- 3.0
@..\ddl\odwavrsn.pkb
@..\ddl\odwactxt.pkb
@..\ddl\cdwp_fil.pkb
@..\ddl\odwarprt.pkb
@..\ddl\odwa_fol.pkb
@..\ddl\odwa_app.pkb
@..\ddl\odwaxist.pkb
-- 3.1
@..\ddl\odwalpad.pkb
@..\ddl\odwasrch.pkb
@..\ddl\odwaspot.pkb
@..\ddl\odwaprop.pkb
@..\ddl\odwagrph.pkb
@..\ddl\odwarobs.pkb
@..\ddl\odwabrow.pkb
@..\ddl\odwainfo.pkb
-- 4.0
@..\ddl\htmltree.pkb
set define off
@..\ddl\odwachck.pkb
@..\ddl\odwachki.pkb
@..\ddl\odwaupld.pkb
@..\ddl\odwapred.pkb
@..\ddl\odwapriv.pkb
@..\ddl\odwahelp.pkb
-- 4.1
@..\ddl\odwadeps.pkb

set define on


rem  
rem  
rem --------------------------------------------------------------------------
rem $$Header_is_done
rem  End of file $RCSfile: robinst.sql $
rem --------------------------------------------------------------------------
rem 
