Oracle DBMS_JMS_PLSQL
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 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