ALL_MLE_PROCEDURES

ALL_MLE_PROCEDURES describes the Oracle Database Multilingual Engine (MLE) functions and procedures accessible to the current user.

Related Views

• DBA_MLE_PROCEDURES describes all MLE functions and procedures in the database.

• USER_MLE_PROCEDURES describes the MLE functions and procedures 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 top-level object For a function or procedure defined in a package or type, this column displays the owner of the package or type. For a standalone function or procedure, this column displays the owner of the function or procedure.
OBJECT_NAME	VARCHAR2(128)	NOT NULL	Name of the top-level object For a function or procedure defined in a package or type, this column displays the name of the package or type. For a standalone function or procedure, this column displays the name of the function or procedure.
PROCEDURE_NAME	VARCHAR2(128)		Name of the function or procedure For a function or procedure defined in a package or type, this column displays the name of the function or procedure. For a standalone function or procedure, the value of this column is null.
OBJECT_ID	NUMBER	NOT NULL	Object number of the object displayed in OBJECT_NAME This value corresponds to the OBJECT_ID column in the ALL_OBJECTS and ALL_PROCEDURES views.
SUBPROGRAM_ID	NUMBER	NOT NULL	Unique subprogram identifier
SIGNATURE	CLOB		Signature of the function or procedure (in the target language)
MODULE_OWNER	VARCHAR2(128)		Owner of the top-level MLE module
MODULE_NAME	VARCHAR2(128)		Name of the top-level MLE module
ENV_OWNER	VARCHAR2(128)		Owner of the MLE environment
ENV_NAME	VARCHAR2(128)		Name of the MLE environment
LANG_OWNER	VARCHAR2(128)		MLE language owner
LANG_NAME	VARCHAR2(128)		MLE language name
SRC	CLOB		Text of the source code for the function or procedure

Note: This view is available starting with Oracle AI Database 26ai.

See Also:

• “DBA_MLE_PROCEDURES”

• “USER_MLE_PROCEDURES”