plginst80.sql

Oracle PL/SQL procedure generator (second generator type)

/******************** PL/Generator from Quest Software *********************
||
|| Installation script for PL/Generator
||  Author: Steven Feuerstein
||
|| This is a part of the PL/Generator Code library.
|| Copyright (C) 1998-1999 Quest Software, Inc.
|| All rights reserved.
||
|| For more information, call Quest Software at 1-800-REVEAL4
|| or check out our Web page: www.Quest Software.com
||
|| Check plginst.log files for errors!
||
|| 03/1999 - Add plgihash, plgtype
||
|| 10/1998 - Add plsql and java drivers
||
|| 09/1998 - All in one installation. Checks for presence of correct
||   PL/Vision version and install if necessary.
||
******************************************************************/

ttitle off
set verify off
set echo off
set serveroutput on size 1000000 

set termout off
set feedback off
set termout on
set feedback on

spool plginst.log

prompt create data structures
REM cleanup from earlier release
DROP PACKAGE plgdbml;

@@plgdata
@@plgdoir.vus

prompt compile package specifications

@@plghash.sf
@@plgadmin.sps
show errors
@@plgbool.sps
show errors
@@plgcols.sps
show errors
@@plgcons.sps
show errors
@@plgfkys.sps
show errors
@@plginds.sps
show errors
@@plgiseg.sps
show errors
@@plgobj.sps
show errors
@@plgofst.sps
show errors
@@plgpky.sps
show errors
@@plgprs.sps
show errors
@@plgstk.sps
show errors
@@plgstr.sps
show errors
@@plgvar.sps
show errors
@@plglst.sps
show errors

@@plgdoir.sps
show errors
@@plgdesc.sps
show errors
@@plggenv.sps
show errors
@@plggen.sps
show errors
@@plgte.sps
show errors
@@plgval.sps
show errors
@@plgerr.sps
show errors
@@plgpriv.sps
show errors
@@plgdrv.sps
show errors

/* 9/98 New packages */
prompt compile plgplsql.sps
@@plgplsql.sps
show errors

prompt compile plgjava.sps
@@plgjava.sps
show errors

/* 3/99 New packages */
prompt compile plgihash.sps
@@plgihash.sps
show errors

prompt compile plgcgml.sps
@@plgcgml.sps
show errors

prompt compile plgtype.sps
@@plgtype.sps
show errors

prompt compile plgsrchash.sps
@@plgsrchash.sps
show errors

/* Package Bodies */

@@plgbool.w80
show errors
@@plgcols.w80
show errors
@@plgcons.w80
show errors
@@plgfkys.w80
show errors
@@plginds.w80
show errors
@@plgiseg.w80
show errors
@@plgobj.w80
show errors
@@plgofst.w80
show errors
@@plgpky.w80
show errors
@@plgprs.w80
show errors
@@plgstk.w80
show errors
@@plgstr.w80
show errors
@@plgvar.w80
show errors
@@plglst.w80
show errors

prompt compile plgte.w80
@@plgte.w80
show errors
prompt compile plgval.w80
@@plgval.w80
show errors
prompt compile plgerr.w80
@@plgerr.w80
show errors
prompt compile plgpriv.w80
@@plgpriv.w80
show errors
prompt compile plgadmin.w80
@@plgadmin.w80
show errors
prompt compile plggen.w80
@@plggen.w80
show errors
prompt compile plgdoir.w80
@@plgdoir.w80
show errors
prompt compile plgdesc.w80
@@plgdesc.w80
show errors
@@plgdrv.w80
show errors

/* 9/98 New packages */
prompt compile plgplsql.w80
@@plgplsql.w80
show errors

prompt compile plgjava.w80
@@plgjava.w80
show errors

/* 3/99 New packages */
prompt compile plgihash.w80
@@plgihash.w80
show errors

prompt compile plgcgml.w80
@@plgcgml.w80
show errors

prompt compile plgtype.w80
@@plgtype.w80
show errors

prompt compile plgsrchash.w80
@@plgsrchash.w80
show errors

/* Confirmation scripts. */
@@plgcnfrm

/* Create fragments of PL/Vision necessary to support the
   current release of the GUI front end. */
REM NO LONGER NEEDED. plvinst
   
GRANT SELECT ON plg_doir TO PUBLIC;
GRANT SELECT ON plg_source TO PUBLIC;
GRANT EXECUTE ON plgdoir TO PUBLIC;
GRANT EXECUTE ON plggen TO PUBLIC;
GRANT EXECUTE ON plggenv TO PUBLIC;
GRANT EXECUTE ON plgte TO PUBLIC;
GRANT EXECUTE ON plgval TO PUBLIC;
GRANT EXECUTE ON plgpriv TO PUBLIC;
GRANT EXECUTE ON plgerr TO PUBLIC;
GRANT EXECUTE ON plgadmin TO PUBLIC;
GRANT EXECUTE ON plgconfirm TO PUBLIC;
GRANT EXECUTE ON plgconfirm_eval TO PUBLIC;

GRANT EXECUTE ON plgplsql TO PUBLIC;
GRANT EXECUTE ON plgjava TO PUBLIC;
GRANT EXECUTE ON plgihash TO PUBLIC;
GRANT EXECUTE ON plgcgml TO PUBLIC;

BEGIN
   plgte.initialize;
   COMMIT;
END;
/

DROP PUBLIC SYNONYM plg_doir;
DROP PUBLIC SYNONYM plg_source;
DROP PUBLIC SYNONYM oir_global_wrap;
DROP PUBLIC SYNONYM oir_schema_wrap;
DROP PUBLIC SYNONYM oir_table_wrap;
DROP PUBLIC SYNONYM oir_driver;
DROP PUBLIC SYNONYM oir_global_tfile;
DROP PUBLIC SYNONYM oir_schema_tfile;
DROP PUBLIC SYNONYM oir_table_tfile;
DROP PUBLIC SYNONYM oir_identifier;
DROP PUBLIC SYNONYM oir_allprivs;
DROP PUBLIC SYNONYM oir_all_generations;
DROP PUBLIC SYNONYM oir_user_generations;

DROP PUBLIC SYNONYM plgdoir;
DROP PUBLIC SYNONYM plggen;
DROP PUBLIC SYNONYM plggenv;
DROP PUBLIC SYNONYM plgte;
DROP PUBLIC SYNONYM plgval;
DROP PUBLIC SYNONYM plgerr;
DROP PUBLIC SYNONYM plgpriv;
DROP PUBLIC SYNONYM plgadmin;
DROP PUBLIC SYNONYM plgplsql;
DROP PUBLIC SYNONYM plgjava;
DROP PUBLIC SYNONYM plgconfirm;
DROP PUBLIC SYNONYM plgconfirm_eval;
DROP PUBLIC SYNONYM plgcgml;

CREATE PUBLIC SYNONYM plg_doir FOR plg_doir;
CREATE PUBLIC SYNONYM plg_source FOR plg_source;
CREATE PUBLIC SYNONYM OIR_ALLPRIVS FOR OIR_ALLPRIVS;
CREATE PUBLIC SYNONYM OIR_GLOBAL_TFILE FOR OIR_GLOBAL_TFILE;
CREATE PUBLIC SYNONYM OIR_GLOBAL_WRAP FOR OIR_GLOBAL_WRAP;
CREATE PUBLIC SYNONYM OIR_IDENTIFIER FOR OIR_IDENTIFIER;
CREATE PUBLIC SYNONYM OIR_SCHEMA_TFILE FOR OIR_SCHEMA_TFILE;
CREATE PUBLIC SYNONYM OIR_SCHEMA_WRAP FOR OIR_SCHEMA_WRAP;
CREATE PUBLIC SYNONYM OIR_TABLE_TFILE FOR OIR_TABLE_TFILE;
CREATE PUBLIC SYNONYM OIR_TABLE_WRAP FOR OIR_TABLE_WRAP;
CREATE PUBLIC SYNONYM OIR_driver FOR OIR_driver;
CREATE PUBLIC SYNONYM oir_all_generations FOR oir_all_generations;
CREATE PUBLIC SYNONYM oir_user_generations FOR oir_user_generations;

CREATE PUBLIC SYNONYM plgdoir FOR plgdoir;
CREATE PUBLIC SYNONYM plggen FOR plggen;
CREATE PUBLIC SYNONYM plggenv FOR plggenv;
CREATE PUBLIC SYNONYM plgte FOR plgte;
CREATE PUBLIC SYNONYM plgval FOR plgval;
CREATE PUBLIC SYNONYM plgpriv FOR plgpriv;
CREATE PUBLIC SYNONYM plgerr FOR plgerr;
CREATE PUBLIC SYNONYM plgadmin FOR plgadmin;
CREATE PUBLIC SYNONYM plgplsql FOR plgplsql;
CREATE PUBLIC SYNONYM plgjava FOR plgjava;
CREATE PUBLIC SYNONYM plgconfirm FOR plgconfirm;
CREATE PUBLIC SYNONYM plgconfirm_eval FOR plgconfirm_eval;
CREATE PUBLIC SYNONYM plgcgml FOR plgcgml;

prompt Load drivers

@@te.ins

@@drvrinit.sql

@@recompile

exec plgconfirm

spool off