Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
DBMS_PIPE , 5 of 11
This function copies the message into the local message buffer.
To receive a message from a pipe, first call RECEIVE_MESSAGE
. When you receive a message, it is removed from the pipe; hence, a message can only be received once. For implicitly-created pipes, the pipe is removed after the last record is removed from the pipe.
If the pipe that you specify when you call RECEIVE_MESSAGE
does not already exist, then Oracle implicitly creates the pipe and waits to receive the message. If the message does not arrive within a designated timeout interval, then the call returns and the pipe is removed.
After receiving the message, you must make one or more calls to UNPACK_MESSAGE
to access the individual items in the message. The UNPACK_MESSAGE
procedure is overloaded to unpack items of type DATE
, NUMBER
, VARCHAR2
, and there are two additional procedures to unpack RAW
and ROWID
items. If you do not know the type of data that you are attempting to unpack, then call NEXT_ITEM_TYPE
to determine the type of the next item in the buffer.
DBMS_PIPE.RECEIVE_MESSAGE ( pipename IN VARCHAR2, timeout IN INTEGER DEFAULT maxwait) RETURN INTEGER;
pragma restrict_references(receive_message,WNDS,RNDS);
Exception | Description |
---|---|
Null pipe name |
Permission error. Insufficient privilege to remove the record from the pipe. The pipe is owned by someone else. |
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|