where i can find paramaters for procedures, functions and packages

[Popeanga Marian_1]

Hello,

I am writing an open source program for Databases http://sourceforge.net/projects/cptd-proj
and i need to know from where to read the parameters of functions, procedures, packages definition ( all_source - but not very sure ). Can anyone point me some good details or some note ?

[Yogeeraj_1]

hi,

ORACLE:
try the DBMS_DESCRIBE package.

if you need any further help, let us know.

Best Regards
Yogeeraj

[Popeanga Marian_1]

Thanks for your info.
If i will need any more help i will inform you.

[Popeanga Marian_1]

I took a look at
Note:1013140.6 Subject: Using the DBMS_DESCRIBE Package from metalink. The datatype is shown as a number. I want something similar to sqlplus describe
Something similar ?

[Yogeeraj_1 · Accepted solution]

hi again,

will user_arguments help?
===========================================================
yd@yd.mydb.MU> desc user_arguments
Name Null? Type
------------------------------- -------- ----
OBJECT_NAME VARCHAR2(30)
PACKAGE_NAME VARCHAR2(30)
OBJECT_ID NOT NULL NUMBER
OVERLOAD VARCHAR2(40)
ARGUMENT_NAME VARCHAR2(30)
POSITION NOT NULL NUMBER
SEQUENCE NOT NULL NUMBER
DATA_LEVEL NOT NULL NUMBER
DATA_TYPE VARCHAR2(30)
DEFAULT_VALUE LONG
DEFAULT_LENGTH NUMBER
IN_OUT VARCHAR2(9)
DATA_LENGTH NUMBER
DATA_PRECISION NUMBER
DATA_SCALE NUMBER
RADIX NUMBER
CHARACTER_SET_NAME VARCHAR2(44)
TYPE_OWNER VARCHAR2(30)
TYPE_NAME VARCHAR2(30)
TYPE_SUBNAME VARCHAR2(30)
TYPE_LINK VARCHAR2(128)
PLS_TYPE VARCHAR2(30)

yd@yd.mydb.MU>
===========================================================

Please let us know.

regards
Yogeeraj

[Popeanga Marian_1]

This really helped.
Thanks!