DBA_METHOD_RESULTS

Description of method results 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)
RESULT_TYPE_MOD VARCHAR2 (7)
Type modifier of the result
RESULT_TYPE_OWNER VARCHAR2 (30)
Owner of the type of the result
RESULT_TYPE_NAME VARCHAR2 (30)
Name of the type of the result
CHARACTER_SET_NAME VARCHAR2 (44)
Character set name of the result

Usage:


  cursor cur_mresult(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 RESULT_TYPE_NAME
  FROM SYS.DBA_METHOD_RESULTS
  where owner = c_owner
  and type_name = c_name
  and method_name = c_method
  and method_no = n_methno;