Re: Scanning a plsql package body to make package headers... regexp requested

If you have access to SQL*Plus, you can get the interface of a function or procedure documented with a fairly straightforward output. Just do

SPOOL output.filename

DESCRIBE PROCEDURE &lt;procedure_name&gt;

SPOOL off
[download]

This yields up output of the form:

PROCEDURE new_item
Argument Name	Type		In/Out      Default?
 ------------------------------ -------  --------------
  FOO		VARCHAR2(28)	   IN
  BAR		VARCHAR2(25)	   IN
  BAZ		VARCHAR2(25)	   IN
  NEWID		NUMBER(38)	   OUT

Which is pretty easy to parse, or may even be the sort of output you wanted in the first place. I'm sure you could even snag such info out of DBI (not that I've tried it ... )

HTH

Philosophy can be made out of anything. Or less -- Jerry A. Fodor

Comment on Re: Scanning a plsql package body to make package headers... regexp requested Download Code