Calls
-
FUNCTION DBMS_PIPE.CREATE_PIPE(pipenameIN VARCHAR2,maxpipesizeIN INTEGER DEFAULT 8192,privateIN BOOLEAN DEFAULT TRUE)RETURN INTEGER; Creates a pipe identified by pipename with maximum size maxpipesize and returns 0. When private is FALSE, the pipe is publicly accessible.
-
FUNCTION DBMS_PIPE.NEXT_ITEM_TYPERETURN INTEGER; Returns an integer identifying the datatype of the next item in the session message buffer.
-
PROCEDURE DBMS_PIPE.PACK_MESSAGE(itemIN {VARCHAR2 | NUMBER | DATE}); Packs item into the session message buffer.
-
PROCEDURE DBMS_PIPE.PACK_MESSAGE_RAW(itemIN RAW); Packs the raw data in item into the session message buffer.
-
PROCEDURE DBMS_PIPE.PACK_MESSAGE_ROWID(itemIN ROWID); Packs the ROWID data in item into the session message buffer.
-
PROCEDURE DBMS_PIPE.PURGE(pipenameIN VARCHAR2); Purges all messages from pipename.
-
FUNCTION DBMS_PIPE.RECEIVE_MESSAGE(pipenameIN VARCHAR2,timeoutIN INTEGER DEFAULT MAXWAIT)RETURN INTEGER; Receives a message from pipename into the session message buffer, waiting for up to timeout seconds for successful completion. Returns 0 for success and 1 for timeout.
-
FUNCTION DBMS_PIPE.REMOVE_PIPE(pipenameIN VARCHAR2)RETURN INTEGER; Removes pipename and frees its memory back to the shared pool, returning 0.
-
PROCEDURE DBMS_PIPE.RESET_BUFFER; Resets the session message buffer’s pack and unpack indicators, effectively discarding all contents.
-
FUNCTION DBMS_PIPE.SEND_MESSAGE(pipenameIN VARCHAR2,timeoutIN INTEGER DEFAULT ...