I stuck sys.dbms_describe.describe_procedure into google and came up with this guys blog:
http://mennan.kagitkalem.com/WhereIsDef ... ments.aspx
This was only posted in June, which is why I didnt find it before.
Anyway I settled on the following if anyone is interested:
Code: Select all
SELECT o.NAME, a.procedure$, a.argument, a.default#, a.default$
FROM sys.obj$ o, sys.argument$ a
WHERE o.obj# = a.obj#
and a.procedure$ = 'MY_PROCEDURE'
AND o.NAME like 'MY_PACKAGE'
Using the OCI call I mentioned above seemed like a lot of effort and parsing all_source would be slow.....
Thanks again
Kevin