General
cancel
Showing results for 
Search instead for 
Did you mean: 

where i can find paramaters for procedures, functions and packages

SOLVED
Go to solution

where i can find paramaters for procedures, functions and packages

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 ?
5 REPLIES
Yogeeraj_1
Honored Contributor

Re: where i can find paramaters for procedures, functions and packages

hi,

ORACLE:
try the DBMS_DESCRIBE package.

if you need any further help, let us know.

Best Regards
Yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)

Re: where i can find paramaters for procedures, functions and packages

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

Re: where i can find paramaters for procedures, functions and packages

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
Honored Contributor
Solution

Re: where i can find paramaters for procedures, functions and packages

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
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)

Re: where i can find paramaters for procedures, functions and packages

This really helped.
Thanks!