UNPACK_MESSAGE v16

Suggest edits

The UNPACK_MESSAGE procedure copies the data items of a message from the local message buffer to a specified program variable. You must place the message in the local message buffer with the RECEIVE_MESSAGE function before using UNPACK_MESSAGE.

UNPACK_MESSAGE(<item> OUT { DATE | NUMBER | VARCHAR2 | RAW })

Parameters

item

Type-compatible variable that receives a data item from the local message buffer.

← Prev

UNIQUE_SESSION_NAME

↑ Up

DBMS_PIPE

Next →

Comprehensive example