Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Where to get package procedure default value from data dictio nary (8.1.7 and 9.2.0.4)

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US