RE: Where to get package procedure default value from data dictio nary (8.1.7 and 9.2.0.4)

From: Feighery Raymond <Raymond.Feighery_at_churchill.com>
Date: Mon, 2 Feb 2004 15:07:50 -0000
Message-ID: <817D2444710B934B9F7B8A1DAAF432D601F2AD39@brcexm03>

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_at_speechmachines.com] Sent: Monday, February 02, 2004 2:10 PM
To: 'oracle-l_at_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_at_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_at_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
-----------------------------------------------------------------

Received on Mon Feb 02 2004 - 09:07:50 CST