Есть "pldoc" ("is an open-source utility for generating HTML documentation of code written in Oracle PL/SQL"). Аналогичен javadoc для Java.
pldoc.sourceforge.net/maven-site
Встроен в oracle sql developer —
www.thatjeffsmith.com/archive/2012/03/javadoc-for-... 
