RE: Where to get package procedure default value from data dictionary (8.1.7 and 9.2.0.4)
- From: "Jamadagni, Rajendra" <Rajendra.Jamadagni@xxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 3 Feb 2004 08:39:55 -0500
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Kresimir Fabijanic
Sent: Tuesday, February 03, 2004 6:31 AM
To: oracle-l@xxxxxxxxxxxxx; tim.onions@xxxxxxxxxxxxxxxxxx
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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
