Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
DBMS_PIPE , 7 of 11
This procedure retrieves items from the buffer.
After you have called RECEIVE_MESSAGE
to place pipe information in a local buffer, call UNPACK_MESSAGE
.
DBMS_PIPE.UNPACK_MESSAGE (item OUT VARCHAR2); DBMS_PIPE.UNPACK_MESSAGE (item OUT NCHAR); DBMS_PIPE.UNPACK_MESSAGE (item OUT NUMBER); DBMS_PIPE.UNPACK_MESSAGE (item OUT DATE); DBMS_PIPE.UNPACK_MESSAGE_RAW (item OUT RAW); DBMS_PIPE.UNPACK_MESSAGE_ROWID (item OUT ROWID);
pragma restrict_references(unpack_message,WNDS,RNDS); pragma restrict_references(unpack_message_raw,WNDS,RNDS); pragma restrict_references(unpack_message_rowid,WNDS,RNDS);
Parameter | Description |
---|---|
item |
Argument to receive the next unpacked item from the local message buffer. |
ORA-06556
or 06559
are generated if the buffer contains no more items, or if the item is not of the same type as that requested.
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|