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@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------