ALL_METHOD_PARAMS

Previous Next JavaScript must be enabled to correctly display this content

2.209 ALL_METHOD_PARAMS

ALL_METHOD_PARAMS describes the method parameters of the object types accessible to the current user.

Related Views

DBA_METHOD_PARAMS describes the method parameters of all object types in the database.
USER_METHOD_PARAMS describes the method parameters of the 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
`METHOD_NO`	`NUMBER`	`NOT NULL`	For an overloaded method, a number distinguishing this method from others of the same. Do not confuse this number with the object ID.
`PARAM_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the parameter
`PARAM_NO`	`NUMBER`	`NOT NULL`	Parameter number (position)
`PARAM_MODE`	`VARCHAR2(6)`		Mode of the parameter (`IN`, `OUT`, `IN OUT`)
`PARAM_TYPE_MOD`	`VARCHAR2(7)`		Whether this parameter is a `REF` to another object
`PARAM_TYPE_OWNER`	`VARCHAR2(128)`		Owner of the type of the parameter
`PARAM_TYPE_NAME`	`VARCHAR2(128)`		Name of the type of the parameter
`CHARACTER_SET_NAME`	`VARCHAR2(44)`		Whether the character set or the method is fixed-length character set (`CHAR_CS`) or fixed-length national character set (`NCHAR_CS`), or a particular character set specified by the user

See Also: