I'm writing SQL to summarise packages/procedures/functions right down to
parameters used, datatypes and defaults values. However, although I can find
a flag that shows whether or not a parameter has a default value or not I
cannot for the life of me see any view or underlying table that tells you a
parameter's default value (argument$ has a column called default$ but this
is always NULL). So, to rephrase, given this mythical function where would I
go in the data dictionary to find the default value "FRED" of parameter
P_Addressee.

FUNCTION fn_Format_Address
  ( P_Addressee    VARCHAR2 := "FRED"
  , P_Address_Line1 VARCHAR2 := NULL
  , P_Address_Line2 VARCHAR2 := NULL
  , P_Address_Line3 VARCHAR2 := NULL
  , P_Address_Line4 VARCHAR2 := NULL
  , P_Postcode     VARCHAR2 := NULL
  , P_Country     VARCHAR2 := NULL
  , P_Telephone    VARCHAR2 := NULL
  , P_Fax        VARCHAR2 := NULL
  , P_Email       VARCHAR2 := NULL
  ) RETURN VARCHAR2
  ;  

Many thanks in advance

T?
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@(protected)
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------