Oracle DBMS_JMS_PLSQL
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 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
Undocumented dbms_jms_plsql.bytes_clean(id IN NUMBER) RETURN NUMBER;
SELECT dbms_jms_plsql.bytes_clean(1)
FROM dual;

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
FROM dual;

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_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
FROM dual;

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
FROM dual;

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

Related Topics
Built-in Functions
Built-in Packages
Database Security
What's New In 19c
What's New In 20c-21c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2022 Daniel A. Morgan All Rights Reserved
  DBSecWorx