genxinst_int.sql

Oracle PL/SQL procedure generator (second generator type)

/******************** GenX from Quest Software *********************
||
|| "Internal" Installation script for GenX and PL/Generator
||  Author: Steven Feuerstein
||
|| This is a part of the GenX 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
||
|| Called by PLGinst and GENXinst
||
******************************************************************/

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

set termout off
set feedback off

REM Detect version and set variables accordingly.
COLUMN col NOPRINT NEW_VALUE v_orcl_vers

SELECT SUBSTR(version,1,3) col
  FROM product_component_version
 WHERE UPPER(product) LIKE 'ORACLE7%'
    OR UPPER(product) LIKE 'PERSONAL ORACLE%'
    OR UPPER(product) LIKE 'ORACLE8%';

COLUMN col NOPRINT NEW_VALUE authidopen
SELECT DECODE (upper('&v_orcl_vers'),
               '8.1', '/**/',
               '/* Oracle 8.1 Only!') col  
  FROM dual;

COLUMN col NOPRINT NEW_VALUE authidclose
SELECT DECODE (upper('&v_orcl_vers'),
               '8.1', '/**/',
               '*/') col  
  FROM dual;
    
@@genxdata
@@plgdoir.vus

REM 2000.2 name conversion package
@@plgnamex.pkg

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.spb
show errors
@@plgcols.spb
show errors
@@plgcons.spb
show errors
@@plgfkys.spb
show errors
@@plginds.spb
show errors
@@plgiseg.spb
show errors
@@plgobj.spb
show errors
@@plgofst.spb
show errors
@@plgpky.spb
show errors
@@plgprs.spb
show errors
@@plgstk.spb
show errors
@@plgstr.spb
show errors
@@plgvar.spb
show errors
@@plglst.spb
show errors

prompt compile plgte.spb
@@plgte.spb
show errors
prompt compile plgval.spb
@@plgval.spb
show errors
prompt compile plgerr.spb
@@plgerr.spb
show errors
prompt compile plgpriv.spb
@@plgpriv.spb
show errors
prompt compile plgadmin.spb
@@plgadmin.spb
show errors
prompt compile plggen.spb
@@plggen.spb
show errors
prompt compile plgdoir.spb
@@plgdoir.spb
show errors
prompt compile plgdesc.spb
@@plgdesc.spb
show errors
@@plgdrv.spb
show errors
prompt compile plgplsql.spb
@@plgplsql.spb
show errors
prompt compile plgjava.spb
@@plgjava.spb
show errors
prompt compile plgihash.spb
@@plgihash.spb
show errors
prompt compile plgcgml.spb
@@plgcgml.spb
show errors
prompt compile plgtype.spb
@@plgtype.spb
show errors
prompt compile plgsrchash.spb
@@plgsrchash.spb
show errors