Message-ID: <817D2444710B934B9F7B8A1DAAF432D601F2AD39@brcexm03>
From: Feighery Raymond <Raymond.Feighery@churchill.com>
To: "'oracle-l@freelists.org'" <oracle-l@freelists.org>
Subject: RE: Where to get package procedure default value from data dictio
 nary (8.1.7 and 9.2.0.4)
Date: Mon, 2 Feb 2004 15:07:50 -0000 
MIME-Version: 1.0
Content-type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Sender: oracle-l-bounce@freelists.org
Errors-To: oracle-l-bounce@freelists.org
Precedence: normal
Reply-To: oracle-l@freelists.org

source$ ?

select s.source
from source$ s, obj$ o
where o.obj#=3Ds.obj#
and o.name =3D 'fn_Format_Address'
/

Ray

-----Original Message-----
From: Tim Onions [mailto:tim.onions@speechmachines.com]
Sent: Monday, February 02, 2004 2:10 PM
To: 'oracle-l@freelists.org'
Subject: Where to get package procedure default value from data
dictionary (8.1.7 and 9.2.0.4)


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 :=3D "FRED"
    , P_Address_Line1  VARCHAR2 :=3D NULL
    , P_Address_Line2  VARCHAR2 :=3D NULL
    , P_Address_Line3  VARCHAR2 :=3D NULL
    , P_Address_Line4  VARCHAR2 :=3D NULL
    , P_Postcode       VARCHAR2 :=3D NULL
    , P_Country        VARCHAR2 :=3D NULL
    , P_Telephone      VARCHAR2 :=3D NULL
    , P_Fax            VARCHAR2 :=3D NULL
    , P_Email          VARCHAR2 :=3D NULL
    ) RETURN VARCHAR2
    ;   =20

Many thanks in advance

T=AC
----------------------------------------------------------------
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
-----------------------------------------------------------------

________________________________________________________________________=
___=20


This email and any attached to it are confidential and intended only =
for the
individual or entity to which it is addressed.  If you are not the =
intended
recipient, please let us know by telephoning or emailing the sender.  =
You
should also delete the email and any attachment from your systems and =
should
not copy the email or any attachment or disclose their content to any =
other
person or entity.  The views expressed here are not necessarily those =
of
Churchill Insurance Group plc or its affiliates or subsidiaries. Thank =
you.=20

Churchill Insurance Group plc.  Company Registration Number - 2280426.
England.=20

Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent =
BR1
1DP.=20


----------------------------------------------------------------
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
-----------------------------------------------------------------