Oracle DBMS_SYS

Oracle DBMS_SYS_MLE Version 21c

General Information

Library Note

Morgan's Library Page Header

Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.

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);