Re: Tool Needed - documenting hundreds of stored procedures

Vic Fraenckel wrote:
>
> I'm looking for a tool which will collect information about stored
> procedures, and dump the results to a file (preferably HTML based) to
> assist in the documentation of several hundred stored procedures. Either
> a third party solution or something internal to Oracle 8i would be fine.
>
> Thanks
>
> Vic Fraenckel
>
> ---------------------------------------------------------------
>
> Name: vhf.vcf
> Part 1.2 Type: text/x-vcard
> Encoding: 7bit
> Description: Card for Vic Fraenckel

Depends on what is required...

ALL_ARGUMENTS gives your the parameter information (as does DESC within SQL Plus), thus

select 'desc '||object_name
from user_objects
where object_type in ('PACKAGE','PROCEDURE','FUNCTION')

or something similar will give some basic information...

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)

"Early to bed and early to rise, 
 makes a man healthy, wealthy and wise." - some dead guy