3.78 ALL_SQLJ_TYPE_METHODS

ALL_SQLJ_TYPE_METHODS describes the methods of the SQLJ object types accessible to the current user.

Related Views

  • DBA_SQLJ_TYPE_METHODS describes the methods of all SQLJ object types in the database.

  • USER_SQLJ_TYPE_METHODS describes the methods of the SQLJ object types owned by the current user. This view does not display the OWNER column.

Column Datatype NULL Description

OWNER

VARCHAR2(128)

NOT NULL

Owner of the type

TYPE_NAME

VARCHAR2(128)

NOT NULL

Name of the type

METHOD_NAME

VARCHAR2(128)

NOT NULL

Name of the method

EXTERNAL_VAR_NAME

VARCHAR2(4000)

Name of the external variable

METHOD_NO

NUMBER

NOT NULL

Method number that distinguishes overloaded methods (not to be used as an ID number)

METHOD_TYPE

VARCHAR2(6)

Type of the method:

  • MAP

  • ORDER

  • PUBLIC

PARAMETERS

NUMBER

NOT NULL

Number of parameters to the method

RESULTS

NUMBER

NOT NULL

Number of results returned by the method

FINAL

VARCHAR2(3)

Indicates whether the method is final (YES) or not (NO)

INSTANTIABLE

VARCHAR2(3)

Indicates whether the method is instantiable (YES) or not (NO)

OVERRIDING

VARCHAR2(3)

Indicates whether the method is overriding a supertype method (YES) or not (NO)

INHERITED

VARCHAR2(3)

Indicates whether the method is inherited from a supertype (YES) or not (NO)