/*=======================================================================+ | Copyright (c) 1995 Oracle Corporation Redwood Shores, California, USA| | All rights reserved. | +=======================================================================+ | FILENAME | wfevdemod.sql | | DESCRIPTION | drop workflow Event Demonstration tables and packages | | NOTES | *=======================================================================*/ /* $Header: wfevdemd.sql 26.2 2003/02/17 17:30:55 rwunderl ship $ */ whenever sqlerror continue; drop package wf_eventdemo; drop table WF_EVENTDEMO_ITEMS; drop table WF_EVENTDEMO_PO; delete from wf_local_user_roles partition (WF_LOCAL_ROLES) where role_name in ('ADMIN','MANAGERS','OTHERS','WORKERS'); delete from wf_local_roles partition (WF_LOCAL_ROLES) where name in ('SYSADMIN','WFADMIN','KWALKER','BLEWIS','SPIERSON','CDOUGLAS', 'ADMIN','MANAGERS','OTHERS','WORKERS'); exit;