Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
DBMS_PIPE , 9 of 11
This procedure empties the contents of the named pipe.
An empty implicitly-created pipe is aged out of the shared global area according to the least-recently-used algorithm. Thus, calling PURGE
lets you free the memory associated with an implicitly-created pipe.
Because PURGE
calls RECEIVE_MESSAGE
, the local buffer might be overwritten with messages as they are purged from the pipe. Also, you can receive an ORA-23322
(insufficient privileges) error if you attempt to purge a pipe with which you have insufficient access rights.
DBMS_PIPE
.PURGE (
pipename IN VARCHAR2);
pragma restrict_references(purge,WNDS,RNDS);
Permission error if pipe belongs to another user.
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|