1. Database Reference
  2. Static Data Dictionary Views
  3. Static Data Dictionary Views: ALL_ALL_TABLES to ALL_OUTLINES
  4. ALL_MLE_PROCEDURES

3.302 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 Database 23ai.

See Also: