rem 
rem 
rem  Will drop all packages owned by a the executing user
rem
rem  Created by Ed Campbell on 7/31/02
rem
rem
rem Set the page size for 
set linesize 132
set pagesize 0
set heading off
set verify off
set echo off
set feedback off
set termout off
spool drop_pkgxxx.sql
prompt spool drop_pkgxxx.lis

SELECT 'DROP PACKAGE '||OBJECT_NAME||';'
  FROM  sys.user_objects
 WHERE object_type = 'PACKAGE';

prompt spool off
spool off
@drop_pkgxxx.sql
prompt Check pkg_drop.lis log file for any errors