/* Formatted by PL/Formatter v.1.1.12 on 1999/03/24 08:39  (08:39 AM) */
/******************** PL/Generator from RevealNet *********************
||
||    File: plgrem.sql
||  Author: Steven Feuerstein
||
|| Removal script for PL/Generator
||
|| This is a part of the PL/Generator Code library.
|| Copyright (C) 1998-1999 RevealNet, Inc.
|| All rights reserved.
||
|| For more information, call RevealNet at 1-800-REVEAL4
|| or check out our Web page: www.revealnet.com
||
|| Don't forget to check the plgrem.log file for errors!
||
******************************************************************/
TTITLE off

SPOOL plgrem.log

REM Clear out earlier beta releases

REM DROP TABLE plg_oir;
REM DROP SEQUENCE plg_oir_seq;
REM DROP PACKAGE plgoir;
REM DROP VIEW OIR_USERPRIVS;

REM Current version

DROP TABLE plg_doir;
DROP SEQUENCE plg_doir_seq;
DROP SEQUENCE plggen_seq;
DROP SEQUENCE PLG_SOURCE_SEQ;
DROP TABLE plg_source;
DROP TABLE plg_driver_source;
DROP TABLE PLGNAMEX_WORD;


DROP VIEW oir_global_wrap;
DROP VIEW oir_schema_wrap;
DROP VIEW oir_table_wrap;
DROP VIEW oir_driver;
DROP VIEW oir_global_file;
DROP VIEW oir_schema_file;
DROP VIEW oir_table_file;
DROP VIEW oir_identifier;
DROP VIEW oir_allprivs;
DROP VIEW oir_all_generations;
DROP VIEW oir_user_generations;
DROP VIEW OIR_DRIVER_SOURCE;
DROP VIEW OIR_USERPRIVS;

DROP PACKAGE plgdoir;
DROP PACKAGE plgdrv;
DROP PACKAGE plggen;
DROP PACKAGE plggenv;
DROP PACKAGE plgte;
DROP PACKAGE plgval;
DROP PACKAGE plgerr;
DROP PACKAGE plgpriv;
DROP PACKAGE plgadmin;
DROP PACKAGE plgdesc;
DROP PACKAGE plgplsql;
DROP PACKAGE plgjava;
DROP PACKAGE PLGBOOL;
DROP PACKAGE PLGCOLS;
DROP PACKAGE PLGCONS;
DROP PACKAGE PLGFKYS;
DROP PACKAGE PLGINDS;
DROP PACKAGE PLGISEG;
DROP PACKAGE PLGLST;
DROP PACKAGE PLGOBJ;
DROP PACKAGE PLGOFST;
DROP PACKAGE PLGPKY;
DROP PACKAGE PLGPRS;
DROP PACKAGE PLGSTK;
DROP PACKAGE PLGSTR;
DROP PACKAGE PLGVAR;
DROP FUNCTION PLGHASH;
DROP PACKAGE PLGIHASH;
DROP PACKAGE PLGcgml;
DROP PACKAGE PLGTYPE;
DROP PACKAGE plgsrchash;
DROP PACKAGE plgnamex;

DROP PROCEDURE plgconfirm;
DROP PROCEDURE plgconfirm_eval;
DROP PROCEDURE genxconfirm;
DROP PROCEDURE genxconfirm_eval;

REM Clear out earlier beta releases
REM DROP PUBLIC SYNONYM plg_oir;
REM DROP PUBLIC SYNONYM plgdoir;
REM DROP PUBLIC SYNONYM OIR_USERPRIVS;

REM Current version

DROP PUBLIC SYNONYM plg_doir;
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 plgnamex;

TTITLE 'PL/Generator Objects Still in Schema'
SELECT object_name, object_type
  FROM user_objects
 WHERE object_name LIKE 'PLG%';
TTITLE OFF

SPOOL OFF