plsql doc - how to generate ALL objects

[kpw]

How do I generate multiple objects (ie package spec and bodies) all at once with the plug-in? And, no, I don't want to purchase Browser Extender, so please don't post that I should buy it. I have 200+ packages I need to generate documentation for and having to do them one by one (in addition to having to regen when we version) would be incredibly tedious. Any help is appreciated. What does get generated when I do them one by one is exactly what I need.

Someone posted this several years back, but, I suppose I'm being dense - how can I run the plug-in command line? I see no documentation regarding that. I tried both regular command line and a sqlplus session which doesn't surprise me that it doesn't work as it most likely cannot find/interpret/recognize the dll....

==============================

/* This is how I do it. Run this in a SQL Window, then paste results in the command window. It will take a long time to finish, so plan on that. Note that our custom code starts with 'Z' and I bet yours is different, so change the object name part!
*/

SELECT 'plugin plsqldoc generate ' || object_name
FROM all_objects
WHERE object_type = 'PACKAGE'
AND status = 'VALID'
AND substr(object_name,1,4) IN ('ZBEN', 'ZPAY', 'ZPER') -- Modify as needed!

 

[Marco Kalter]

The resulting commands can be executed in the Command Window. For example:

plugin plsqldoc generate employee

This generates the documentation for object employee. The query creates these statements for an arbitrary selection of objects.

 

[kpw]

Oh DUH - a command window WITHIN PL/SQL Developer. Ok, thanks - that worked!