plsqldoc - Questions and Enhancements

[Daniel Thei]

Hi,
I have one question and one enhancement...

First the enhancement: It would be great to have a link between the tables and appendant triggers

Now the question:
To generate the documentation in batch process I create an output file with a statement like this:

spool output;
SELECT DISTINCT 'plugin plsqldoc generate ' || o.object_name FROM all_objects o WHERE o.owner = 'HERO';
spool off;

Than I start the output file. For each of the following types I get an error message:

• SEQUENCE -> "Failed!"
• Index -> "Failed!" or "Unknown object"
• Java Class -> "Unknown object"
• PRIMARY KEY -> "Failed!"
• LIBRARY -> "Unknown object"
• UNIQUE KEY -> "Failed!"
• LOB -> "Unknown object"

Which Types support plsqldoc ?

Here another question:
If you try in the command-window to generate the documentation for a trigger and a sequence with the same name (For example: Trigger "s_table", Sequence "s_table") you get the error-message:
"Generating SEQUENCE SERO.S_table
Failed!"
It is possible to assign the type of the object in the command-window ???

I hope you will understand my explanations.

Thanx
D.Thei

 

[Marco Kalter]

All PL/SQL program unit types are supported, and tables and views.

We'll check out the duplicate name issue. At the moment sequences cannot be documented, so it would have made sense to select the trigger instead. An object type parameter would be best of course.

 

[Daniel Thei]

Thanx for your reply.

 

[baloo]

Hi Marco,
something new with this enhancement?
Thanks,
ondrej

 

[Marco Kalter]

Not yet. Which part of the enhancement do you need?