Listing contents of stored procedures 1

[mahesh736]

Is there any way I can programitically list the contents of all package bodies to a file?

The query,
"select * from sys.user_objects where object_type = 'PACKAGE BODY'"
gives me just the names of all the package bodies.

Which table stores the contents of the package bodies?

Thanks

 

[ThomVF]

This gives you the actual code for a procedure:

select name, type, line, text
from user_source
where type = 'PROCEDURE'
and name = '<procedure name>'
order by name, line &quot;Helping others to help themselves...&quot;
=================================
Thomas V. Flaherty Jr.
Birch Hill Technology Group, Inc.

http://www.birchhillgroup.com

 

[ThomVF]

Here are the types of objects you can get from USER/ALL/DBA_SOURCE:

TYPE
------------
FUNCTION
PACKAGE
PACKAGE BODY
PROCEDURE
TYPE &quot;Helping others to help themselves...&quot;
=================================
Thomas V. Flaherty Jr.
Birch Hill Technology Group, Inc.

http://www.birchhillgroup.com