Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i12EN3t12326 for ; Mon, 2 Feb 2004 08:23:03 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i12EN2o12321 for ; Mon, 2 Feb 2004 08:23:02 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A3BE6394BC8; Mon, 2 Feb 2004 09:19:35 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Mon, 02 Feb 2004 09:18:46 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from smcorps0002.smcorp.speechmachines.com (mail.speechmachines.com [193.132.150.21]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 395C73949CA for ; Mon, 2 Feb 2004 09:18:41 -0500 (EST) Received: by smcorps0002.smcorp.speechmachines.com with Internet Mail Service (5.5.2653.19) id ; Mon, 2 Feb 2004 14:10:24 -0000 Message-ID: From: Tim Onions To: "'oracle-l@freelists.org'" Subject: Where to get package procedure default value from data dictionary (8.1.7 and 9.2.0.4) Date: Mon, 2 Feb 2004 14:10:16 -0000 X-Mailer: Internet Mail Service (5.5.2653.19) X-archive-position: 536 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: tim.onions@speechmachines.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l 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@freelists.org 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 -----------------------------------------------------------------