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

From: Tanel Poder <tanel.poder.003_at_mail.ee>
Date: Tue, 3 Feb 2004 19:51:09 +0200
Message-ID: <08fb01c3ea7e$4e94f670$eafb23d5@porgand>

Hi!

It's going to idl_char$, but not in easily parseable and usable format... The long column in argument$ is probably a leftover from some earlier plsql versions...

Tanel.

• Original Message ----- From: "Jamadagni, Rajendra" <Rajendra.Jamadagni_at_espn.com> To: <oracle-l_at_freelists.org> Sent: Tuesday, February 03, 2004 3:39 PM Subject: RE: Where to get package procedure default value from data dictionary (8.1.7 and 9.2.0.4)

> 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
> -----------------------------------------------------------------
>

---

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 - 11:51:09 CST