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

From: Tim Onions <tim.onions_at_speechmachines.com>
Date: Mon, 2 Feb 2004 14:59:10 -0000
Message-ID: <A90A3AC3D202D311909A0090271E4C81032104E7@smcorps0002.smcorp.speechmachines.com>

Ray

Thanks for the suggestion - I was rather hoping I could get the default value without having to parse through the source$/user_source tables. But, yes, if I have then I can do.

T¬

-----Original Message-----

From: Feighery Raymond [mailto:Raymond.Feighery_at_churchill.com]

source$ ?

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

---

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 - 08:59:10 CST