Home » RDBMS Server » Server Administration » How to join DBA_TYPE_METHODS and DBA_ARGUMENTS (11.2)
How to join DBA_TYPE_METHODS and DBA_ARGUMENTS [message #640340] Mon, 27 July 2015 07:48
Michel Cadot
Messages: 65317
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

I try to find the arguments of type methods.
So the frame is to join DBA_TYPE_METHODS and DBA_ARGUMENTS (maybe using intermediate views like DBA_PROCEDURES):
SQL> desc dba_type_methods
 Name                                   Null?    Type
 -------------------------------------- -------- --------------------------
 OWNER                                  NOT NULL VARCHAR2(30)
 TYPE_NAME                              NOT NULL VARCHAR2(30)
 METHOD_NAME                            NOT NULL VARCHAR2(30)
 METHOD_NO                              NOT NULL NUMBER
 METHOD_TYPE                                     VARCHAR2(6)
 PARAMETERS                             NOT NULL NUMBER
 RESULTS                                NOT NULL NUMBER
 FINAL                                           VARCHAR2(3)
 INSTANTIABLE                                    VARCHAR2(3)
 OVERRIDING                                      VARCHAR2(3)
 INHERITED                                       VARCHAR2(3)

SQL> desc dba_arguments
 Name                                   Null?    Type
 -------------------------------------- -------- --------------------------
 OWNER                                  NOT NULL VARCHAR2(30)
 OBJECT_NAME                                     VARCHAR2(30)
 PACKAGE_NAME                                    VARCHAR2(30)
 OBJECT_ID                              NOT NULL NUMBER
 OVERLOAD                                        VARCHAR2(40)
 SUBPROGRAM_ID                                   NUMBER
 ARGUMENT_NAME                                   VARCHAR2(30)
 POSITION                               NOT NULL NUMBER
 SEQUENCE                               NOT NULL NUMBER
 DATA_LEVEL                             NOT NULL NUMBER
 DATA_TYPE                                       VARCHAR2(30)
...

My first idea was:
owner       <=> owner
type_name   <=> package_name
method_name <=> object_name
but some methods can be overloaded (something that is not indicated in dba_type_methods), so it comes:
owner       <=> owner
type_name   <=> package_name
method_name <=> object_name
method_no   <=> subprogram_id
but the last condition is wrong, too simple. Sad

If anyone has an idea how to get the arguments of a type method from the dictionary, it'd be welcome.

Edit: cross-ref http://www.dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=77942

[Updated on: Mon, 27 July 2015 08:29]

Report message to a moderator

Previous Topic: Oracle client connectivity to Database in different Windows work Domain
Next Topic: undo tablespace responsibility??
Goto Forum:
  


Current Time: Fri Jan 19 23:59:37 CST 2018

Total time taken to generate the page: 0.01571 seconds