DBA_METHOD_PARAMS

Description of method parameters of all types in the database

Name Datatype Length Mandatory Comments
OWNER VARCHAR2 (30) Yes Onwer of the type
TYPE_NAME VARCHAR2 (30) Yes Name of the type
METHOD_NAME VARCHAR2 (30) Yes Name of the method
METHOD_NO NUMBER
Yes Method number for distinguishing overloaded method (not to be used as ID number)
PARAM_NAME VARCHAR2 (30) Yes Name of the parameter
PARAM_NO NUMBER
Yes Parameter number or position
PARAM_MODE VARCHAR2 (6)
Mode of the parameter
PARAM_TYPE_MOD VARCHAR2 (7)
Type modifier of the parameter
PARAM_TYPE_OWNER VARCHAR2 (30)
Owner of the type of the parameter
PARAM_TYPE_NAME VARCHAR2 (30)
Name of the type of the parameter
CHARACTER_SET_NAME VARCHAR2 (44)
Character set name of the parameter

Usage:


  cursor cur_mparam(c_name   in dba_types.type_name%type
                  , c_owner  in dba_types.owner%type
                  , c_method in dba_method_params.method_name%type
                  , n_methno in dba_method_params.method_no%type) is

  SELECT PARAM_NAME
  ,      PARAM_NO
  ,      PARAM_TYPE_NAME
  FROM SYS.DBA_METHOD_PARAMS
  where owner = c_owner
  and type_name = c_name
  and method_name = c_method
  and method_no = n_methno
  order by param_no;