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

From: Jamadagni, Rajendra <Rajendra.Jamadagni_at_espn.com>
Date: Tue, 3 Feb 2004 08:39:55 -0500
Message-ID: <A186CBDC8B1D61438BC50F1A77E91F73057C18B3@xchgbrsm1.corp.espn.pvt>

Yeah ... but the value Tim looking for isn't there. I traced a 'create = or replace procedure' with default value the default# gets a value of 1 = to indicate there is a default value, but the default value itself = doesn't get inserted into any of the sys tables. No so sure about what = goes in the idl tables though.

The default value is supposed to be stored in default$ column which is a = long ...
Raj
-------------------------------------------------------------------------=

---

Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art !

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

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Kresimir Fabijanic Sent: Tuesday, February 03, 2004 6:31 AM To: oracle-l_at_freelists.org; tim.onions_at_speechmachines.com Subject: Re: Where to get package procedure default value from data dictionary (8.1.7 and 9.2.0.4)

Hi Tim

The catalog view you are looking for is ALL_ARGUMENTS:

Name Type Null =3D20

OWNER VARCHAR2(30) No =3D20
OBJECT_NAME VARCHAR2(30) Yes =3D20 PACKAGE_NAME VARCHAR2(30) Yes =3D20 OBJECT_ID NUMBER No =3D20
OVERLOAD VARCHAR2(40) Yes =3D20
ARGUMENT_NAME VARCHAR2(30) Yes =3D20 POSITION NUMBER No =3D20
SEQUENCE NUMBER No =3D20
DATA_LEVEL NUMBER No =3D20
DATA_TYPE VARCHAR2(30) Yes =3D20
DEFAULT_VALUE LONG Yes =3D20
DEFAULT_LENGTH NUMBER Yes =3D20
IN_OUT VARCHAR2(9) Yes =3D20

DATA_LENGTH    NUMBER    Yes  =3D20
DATA_PRECISION    NUMBER    Yes  =3D20
DATA_SCALE    NUMBER    Yes  =3D20

RADIX NUMBER Yes =3D20
CHARACTER_SET_NAME VARCHAR2(44) Yes =3D20

TYPE_OWNER    VARCHAR2(30)    Yes  =3D20
TYPE_NAME    VARCHAR2(30)    Yes  =3D20
TYPE_SUBNAME    VARCHAR2(30)    Yes  =3D20
TYPE_LINK    VARCHAR2(128)    Yes  =3D20

PLS_TYPE VARCHAR2(30) Yes =3D20

for e.g dbms_lock.sleep:

select * from all_arguments
where owner =3D3D 'SYS'
and package_name =3D3D 'DBMS_JOB'
and object_name =3D3D 'SUBMIT'

That view in turn uses the obj$ and argument$ Oracle internal = structures:=3D

select *
from sys.argument$ a, sys.obj$ o
where a.procedure$ =3D3D 'SUBMIT'
and a.obj# =3D3D o.obj#
and o.name =3D3D 'DBMS_JOB'

HTH Kind Regards

Kresimir Fabijanic

---

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 Tue Feb 03 2004 - 07:39:55 CST