Oracle | DBMS_JMS

Oracle DBMS_JMS_PLSQL Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows

Purpose Streams Java Messaging Metrics API

AUTHID CURRENT_USER

Dependencies

AQ$_JMS_BYTES_MESSAGE	AQ$_JMS_NAMEARRAY	AQ$_JMS_VALUE
AQ$_JMS_EXCEPTION	AQ$_JMS_STREAM_MESSAGE	DBMS_SYS_ERROR
AQ$_JMS_MAP_MESSAGE

Documented No

First Available Not known

Security Model Owned by SYS with no privileges granted

Source {ORACLE_HOME}/rdbms/admin/prvtaqji.plb
{ORACLE_HOME}/rdbms/admin/prvtaqal.plb

Subprograms

BYTES_CLEAN	JAVA_CONVERT_JMS_SELECTOR	MAP_SET_STRING
BYTES_CLEAN_ALL	MAP_CLEAN	STREAM_CLEAN
BYTES_CLEAR_BODY	MAP_CLEAN_ALL	STREAM_CLEAN_ALL
BYTES_FLUSH	MAP_CLEAR_BODY	STREAM_CLEAR_BODY
BYTES_GET_MODE	MAP_FLUSH	STREAM_FLUSH
BYTES_PREPARE	MAP_GET_BYTES	STREAM_GET_MODE
BYTES_READ_BYTES	MAP_GET_CHAR	STREAM_PREPARE
BYTES_READ_CHAR	MAP_GET_NAMES	STREAM_READ_BYTES
BYTES_READ_NUMBER	MAP_GET_NUMBER	STREAM_READ_CHAR
BYTES_READ_UTF	MAP_GET_OBJECT	STREAM_READ_NUMBER
BYTES_RESET	MAP_GET_SIZE	STREAM_READ_OBJECT
BYTES_WRITE_BYTES	MAP_GET_STRING	STREAM_READ_STRING
BYTES_WRITE_CHAR	MAP_ITEM_EXISTS	STREAM_RESET
BYTES_WRITE_NUMBER	MAP_PREPARE	STREAM_WRITE_BYTES
BYTES_WRITE_UTF	MAP_SET_BYTES	STREAM_WRITE_CHAR
CONVERT_JMS_SELECTOR	MAP_SET_CHAR	STREAM_WRITE_NUMBER
GET_ERROR_TEXT	MAP_SET_NUMBER	STREAM_WRITE_STRING
GET_EXCEPTION

BYTES_CLEAN

Undocumented dbms_jms_plsql.bytes_clean(id IN NUMBER) RETURN NUMBER;

SELECT dbms_jms_plsql.bytes_clean(1);

      

      DBMS_JMS_PLSQL.BYTES_CLEAN(1)

      -----------------------------

                             -24198

BYTES_CLEAN_ALL

Undocumented dbms_jms_plsql.bytes_clean_all RETURN NUMBER

SELECT dbms_jms_plsql.bytes_clean_all;

      

      BYTES_CLEAN_ALL

      ---------------

                    0

BYTES_CLEAR_BODY

Undocumented dbms_jms_plsql.bytes_clear_body( id IN NUMBER, new_id OUT NUMBER) RETURN NUMBER;

TBD

BYTES_FLUSH

Undocumented dbms_jms_plsql.bytes_flush( id IN NUMBER, bytes_len OUT NUMBER, bytes_raw OUT RAW, bytes_lob IN OUT BLOB) RETURN NUMBER;

TBD

BYTES_GET_MODE

Undocumented dbms_jms_plsql.bytes_get_mode( id IN NUMBER, access_mode OUT NUMBER) RETURN NUMBER;

TBD

BYTES_PREPARE

Undocumented dbms_jms_plsql.bytes_prepare( id IN NUMBER, new_id OUT NUMBER, bytes_raw IN RAW, bytes_lob IN BLOB) RETURN NUMBER;

TBD

BYTES_READ_BYTES

Undocumented dbms_jms_plsql.bytes_read_bytes( id IN NUMBER, blob_value IN OUT BLOB, length IN NUMBER, readlen OUT NUMBER) RETURN NUMBER;

TBD

BYTES_READ_CHAR

Undocumented dbms_jms_plsql.bytes_read_char( id IN NUMBER, char_value OUT CHAR) RETURN NUMBER;

TBD

BYTES_READ_NUMBER

Undocumented dbms_jms_plsql.bytes_read_number( id IN NUMBER, value OUT NUMBER, type IN NUMBER) RETURN NUMBER;

TBD

BYTES_READ_UTF

Undocumented dbms_jms_plsql.bytes_read_utf( id IN NUMBER, clob_value IN OUT CLOB) RETURN NUMBER;

TBD

BYTES_RESET

Undocumented dbms_jms_plsql.bytes_reset(id IN NUMBER) RETURN NUMBER;

TBD

BYTES_WRITE_BYTES

Undocumented

Overload 1 dbms_jms_plsql.bytes_write_bytes( id IN NUMBER, value IN RAW, offset IN NUMBER, length IN NUMBER) RETURN NUMBER;

TBD

Overload 2 dbms_jms_plsql.bytes_write_bytes( id IN NUMBER, value IN BLOB, offset IN NUMBER, length IN NUMBER) RETURN NUMBER;

TBD

BYTES_WRITE_CHAR

Undocumented dbms_jms_plsql.bytes_write_char( id IN NUMBER, value IN CHAR) RETURN NUMBER;

TBD

BYTES_WRITE_NUMBER

Undocumented dbms_jms_plsql.bytes_write_number( id IN NUMBER, value IN NUMBER, type IN NUMBER) RETURN NUMBER;

TBD

BYTES_WRITE_UTF

Undocumented

Overload 1 dbms_jms_plsql.bytes_write_utf( id IN NUMBER, value IN VARCHAR2) RETURN NUMBER;

TBD

Overload 2 dbms_jms_plsql.bytes_write_utf( id IN NUMBER, value IN CLOB) RETURN NUMBER;

TBD

CONVERT_JMS_SELECTOR

Undocumented

Overload 1 dbms_jms_plsql.convert_jms_selector(selector IN VARCHAR2) RETURN VARCHAR2;

TBD

Overload 2 dbms_jms_plsql.convert_jms_selector( selector IN VARCHAR2, dest_pload_type IN BINARY_INTEGER) RETURN VARCHAR2;

TBD

Overload 3 dbms_jms_plsql.convert_jms_selector( selector IN VARCHAR2, dest_pload_type IN BINARY_INTEGER, compliant IN BOOLEAN) RETURN VARCHAR2;

TBD

GET_ERROR_TEXT (new 23ai)

Undocumented dbms_jms_plsql.get_error_text RETURN VARCHAR2;

SELECT dbms_jms_plsql.get_error_text;

      

      GET_ERROR_TEXT

      -----------------------------

GET_EXCEPTION

Undocumented dbms_jms_plsql.get_exception( exp OUT sys.aq$jms_exception, null_ind OUT NUMBER) RETURN NUMBER;

TBD

JAVA_CONVERT_JMS_SELECTOR

Undocumented dbms_jms_plsql.java_convert_jms_selector( selector IN VARCHAR2, dest_pload_type IN NUMBER, compliant IN NUMBER, rule OUT VARCHAR2) RETURN NUMBER;

TBD

MAP_CLEAN

Undocumented dbms_jms_plsql.map_clean(id IN NUMBER) RETURN NUMBER;

TBD

MAP_CLEAN_ALL

Undocumented dbms_jms_plsql.map_clean_all RETURN NUMBER;

SELECT dbms_jms_plsql.map_clean_all;

      

      MAP_CLEAN_ALL

      -------------

                  0

MAP_CLEAR_BODY

Undocumented dbms_jms_plsql.map_clear_body( id IN NUMBER, new_id OUT NUMBER) RETURN NUMBER;

TBD

MAP_FLUSH

Undocumented dbms_jms_plsql.map_flush( id IN NUMBER, bytes_len OUT NUMBER, bytes_raw OUT RAW, bytes_lob IN OUT BLOB) RETURN NUMBER;

TBD

MAP_GET_BYTES

Undocumented dbms_jms_plsql.map_get_bytes( id IN NUMBER, name IN VARCHAR2, blob_value IN OUT BLOB) RETURN NUMBER;

TBD

MAP_GET_CHAR

Undocumented dbms_jms_plsql.map_get_char( id IN NUMBER, name IN VARCHAR2, char_value OUT CHAR) RETURN NUMBER;

TBD

MAP_GET_NAMES

Undocumented

Overload 1 dbms_jms_plsql.map_get_names( id IN NUMBER, value OUT sys.aq$jms_namearray) RETURN NUMBER;

TBD

Overload 2 dbms_jms_plsql.map_get_names( id IN NUMBER, value OUT sys.aq$jms_namearray, offset IN NUMBER, length IN NUMBER, retrieved OUT NUMBER) RETURN NUMBER;

TBD

MAP_GET_NUMBER

Undocumented dbms_jms_plsql.map_get_number( id IN NUMBER, name IN VARCHAR2, value OUT NUMBER, type IN NUMBER) RETURN NUMBER;

TBD

MAP_GET_OBJECT

Undocumented dbms_jms_plsql.map_get_object( id IN NUMBER, name IN VARCHAR2, value IN OUT sys.aq$jms_value, null_ind OUT NUMBER) RETURN NUMBER

TBD

MAP_GET_SIZE

Undocumented dbms_jms_plsql.map_get_size( id IN NUMBER, map_size OUT NUMBER) RETURN NUMBER;

TBD

MAP_GET_STRING

Undocumented dbms_jms_plsql.map_get_string( id IN NUMBER, name IN VARCHAR2, clob_value IN OUT CLOB) RETURN NUMBER;

TBD

MAP_ITEM_EXISTS

Undocumented dbms_jms_plsql.map_item_exists( id IN NUMBER, name IN VARCHAR2, value OUT NUMBER) RETURN NUMBER;

TBD

MAP_PREPARE

Undocumented dbms_jms_plsql.map_prepare( id IN NUMBER, new_id OUT NUMBER, bytes_raw IN RAW, bytes_lob IN BLOB) RETURN NUMBER;

TBD

MAP_SET_BYTES

Undocumented

Overload 1 dbms_jms_plsql.map_set_bytes( id IN NUMBER, name IN VARCHAR2, value IN RAW, offset IN NUMBER, length IN NUMBER) RETURN NUMBER;

TBD

Overload 2 dbms_jms_plsql.map_set_bytes( id IN NUMBER, name IN VARCHAR2, value IN BLOB, offset IN NUMBER, length IN NUMBER) RETURN NUMBER;

TBD

MAP_SET_CHAR

Undocumented dbms_jms_plsql.map_set_char( id IN NUMBER, name IN VARCHAR2, value IN CHAR) RETURN NUMBER;

TBD

MAP_SET_NUMBER

Undocumented dbms_jms_plsql.map_set_number( id IN NUMBER, name IN VARCHAR2, value IN NUMBER, type IN NUMBER) RETURN NUMBER;

TBD

MAP_SET_STRING

Undocumented

Overload 1 dbms_jms_plsql.map_set_string( id IN NUMBER, name IN VARCHAR2, value IN VARCHAR2) RETURN NUMBER;

TBD

Overload 2 dbms_jms_plsql.map_set_string( id IN NUMBER, name IN VARCHAR2, value IN CLOB) RETURN NUMBER;

TBD

STREAM_CLEAN

Undocumented dbms_jms_plsql.stream_clean(id IN NUMBER) NUMBER;

TBD

STREAM_CLEAN_ALL

Undocumented dbms_jms_plsql.stream_clean_all RETURN NUMBER;

SELECT dbms_jms_plsql.stream_clean_all;

      

      STREAM_CLEAN_ALL

      ----------------

                     0

STREAM_CLEAR_BODY

Undocumented dbms_jms_plsql.stream_clear_body( id IN NUMBER, new_id OUT NUMBER) RETURN NUMBER;

TBD

STREAM_FLUSH

Undocumented dbms_jms_plsql.stream_flush( id IN NUMBER, bytes_len OUT NUMBER, bytes_raw OUT RAW, bytes_lob IN OUT BLOB) RETURN NUMBER;

TBD

STREAM_GET_MODE

Undocumented dbms_jms_plsql.stream_get_mode( id IN NUMBER, access_mode OUT NUMBER) RETURN NUMBER;

TBD

STREAM_PREPARE

Undocumented dbms_jms_plsql.stream_prepare( id IN NUMBER, new_id OUT NUMBER, bytes_raw IN RAW, bytes_lob IN BLOB) RETURN NUMBER;

TBD

STREAM_READ_BYTES

Undocumented dbms_jms_plsql.stream_read_bytes( id IN NUMBER, blob_value IN OUT BLOB) RETURN NUMBER;

TBD

STREAM_READ_CHAR

Undocumented dbms_jms_plsql.stream_read_char( id IN NUMBER, char_value OUT CHAR) RETURN NUMBER;

TBD

STREAM_READ_NUMBER

Undocumented dbms_jms_plsql.stream_read_number( id IN NUMBER, value OUT NUMBER, type IN NUMBER) RETURN NUMBER;

TBD

STREAM_READ_OBJECT

Undocumented dbms_jms_plsql.stream_read_object( id IN NUMBER, value IN OUT sys.aq$_jms_value, null_ind OUT NUMBER) RETURN NUMBER

TBD

STREAM_READ_STRING

Undocumented dbms_jms_plsql.stream_read_string( id IN NUMBER, clob_value IN OUT CLOB) RETURN NUMBER;

TBD

STREAM_RESET

Undocumented dbms_jms_plsql.stream_reset(id IN NUMBER) RETURN NUMBER;

TBD

STREAM_WRITE_BYTES

Undocumented

Overload 1 dbms_jms_plsql.stream_write_bytes( id IN NUMBER, value IN RAW, offset IN NUMBER, length IN NUMBER) RETURN NUMBER;

TBD

Overload 2 dbms_jms_plsql.stream_write_bytes( id IN NUMBER, value IN BLOB, offset IN NUMBER, length IN NUMBER) RETURN NUMBER;

TBD

STREAM_WRITE_CHAR

Undocumented dbms_jms_plsql.stream_write_char( id IN NUMBER, value IN CHAR) RETURN NUMBER;

TBD

STREAM_WRITE_NUMBER

Undocumented dbms_jms_plsql.stream_write_number( id IN NUMBER, value IN NUMBER, type IN NUMBER) RETURN NUMBER;

TBD

STREAM_WRITE_STRING

Undocumented

Overload 1 dbms_jms_plsql.stream_write_string( id IN NUMBER, value IN VARCHAR2) RETURN NUMBER;

TBD

Overload 2 dbms_jms_plsql.stream_write_string( id IN NUMBER, value IN CLOB) RETURN NUMBER;

TBD