Oracle | DBMS_SYS

Oracle DBMS_SYS_MLE Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

Purpose This Multi-Lingual Engine (MLE) package provides internal support for DBMS_MLE creating a seamless interface between PL/SQL and JavaScript.

AUTHID CURRENT_USER

Dependencies

DBMS_MLE

UTL_IDENT

Documented No

First Available 21c

Security Model Owned by SYS with no privileges granted.

Source {ORACLE_HOME}/rdbms/admin/prvthsmle.plb

Subprograms

CREATE_CONTEXT_AS_USER	DISABLE_STDOUT	SET_STDOUT
CREATE_CONTEXT_AS_XS_SESSION	SET_STDERR	SET_STDOUT_TO_DBMS_OUTPUT
DISABLE_STDERR	SET_STDERR_TO_DBMS_OUTPUT

CREATE_CONTEXT_AS_USER (new 21c)

Undocumented dbms_sys_mle.create_context_as_user( user_id IN BINARY_INTEGER, uselogonroles IN BOOLEAN, edition IN VARCHAR2) RETURN RAW;

TBD

CREATE_CONTEXT_AS_XS_SESSION (new 21c)

Undocumented dbms_sys_mle.create_context_as_xs_session( xs_sessionid IN RAW, ediiton IN VARCHAR2, schema IN VARCHAR2) RETURN RAW;

TBD

DISABLE_STDERR (new 21c)

Disables the stderr stream of all MLE contexts, so that future writes to stderr are discarded dbms_sys_mle.disable_stderr(user_id IN BINARY_INTEGER);

exec dbms_sys_mle.disable_stderr(105);

DISABLE_STDOUT (new 21c)

Disables the stdout stream of all MLE contexts, so that future writes to stdout are discarded dbms_sys_mle.disable_stdout(user_id IN BINARY_INTEGER);

exec dbms_sys_mle.disable_stdout(105);

SET_STDERR (new 21c)

Redirect the stderr stream of all MLE contexts to the given CLOB dbms_sys_mle.set_stderr( user_id IN BINARY_INTEGER, sink IN OUT CLOB);

TBD

SET_STDERR_TO_DBMS_OUTPUT (new 21c)

Redirect the stderr stream of all MLE contexts to DBMS_OUTPUT dbms_sys_mle.set_stderr_to_dbms_output(user_id IN BINARY_INTEGER);

SET_STDOUT (new 21c)

Redirect the stdout stream of all MLE contexts to the given CLOB dbms_sys_mle.set_stdout( user_id IN BINARY_INTEGER, sink IN OUT CLOB);

SET_STDOUT_TO_DBMS_OUTPUT (new 21c)

Redirect the stdout stream of all MLE contexts to DBMS_OUTPUT dbms_sys_mle.set_stdout_to_dbms_output(user_id IN BINARY_INTEGER);

exec dbms_sys_mle.set_stdout_to_dbms_output(105);