There is a very minor glitch in Rodd's script - ORDER BY should be by
name, TYPE, line - simply because PACKAGE and PACKAGE BODY bear the same
name. I presume that the original version had
type = 'PACKAGE BODY',
not
type like 'PACKAGE%'
--
Regards,
Stephane Faroult
email: sfaroult_at_oriolecorp.com
Oriole Corporation
Voice: +44 (0) 7050-696-269
Fax: +44 (0) 7050-696-449
Performance Tools & Free Scripts
------------------------------------------------------------------
http://www.oriolecorp.com, designed by Oracle DBAs for Oracle DBAs
------------------------------------------------------------------
>
> I give!
> I'll make it easier. Here's a script that pulls it from the data dictionary
> to a spool file. Add another where clause to specify the package name and
> you can narrow it down to specifics. This script as it is will pull all the
> packages for a given user. It is ment to be run from SQL*Plus so that you
> can format the output into standard readable output with lines joined and
> everything.
>
> set feedback off
> set pagesize 60
> set linesize 200
> set newpage 0
> break on name skip page
> col " " format a80 wrapped
>
> select decode(line,1,'CREATE OR REPLACE ',null) as "/", text as " "
> from dba_source
> where owner = '<SCHEMA OWNER>'
> and type like 'PACKAGE%'
> order by name, line;
>
> -- The following command creates the terminating slash at the end of the
> script.
> set heading off
> select '/'
> from dual;
>
> clear breaks
> clear columns
> clear buffer
> set heading on
> set linesize 200
> set pagesize 60
> set feedback on
>
> Rodd Holman
> Enterprise Data Systems Engineer
> LodgeNet Entertainment Corporation
> rodney.holman_at_lodgenet.com
> Comments made are my own opinions and views. They do not represent views,
> policies, or procedures of LodgeNet Entertainment Corpor
Received on Fri Oct 27 2000 - 03:40:22 CDT
