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;