Oracle PL/SQL Programming: A Developer's Workbook

Chapter 22. DBMS_PIPE Built-in Package

Beginner

Q:
22-1.	Absolutely not! That is one of the hallmarks and key advantages of DBMS_PIPE: it operates outside your session’s transaction boundaries.
Q:
22-2.	Here are the required steps in the proper order: Pack data into the message buffer Send the message The steps in the following table aren’t required; the reasons they can be skipped accompany them. Step Why Skip? Check to make sure the pipe exists If the pipe does not exist, it is created for you when you send the message. Convert all numeric and date information to VARCHAR2 before packing it into the message buffer You can pack dates and numbers directly into the buffer with a call to the overloaded DBMS_PIPE.PACK_MESSAGE procedure. Create the pipe If the pipe does not exist, it is created for you when you send the message. Check the status of the send operation This is a very good and recommended thing to do, but it is not required.
Q:
22-3.	Here are the required steps in the proper order: Receive the message Unpack individual packets of data from the message buffer The steps in the following table aren’t required; the reasons they can be skipped accompany them. Step Why Skip? Check to make sure the pipe exists If the pipe does not exist, it is created for you when you send the message. Send a “message received” confirmation message back on the same pipe There is no requirement to respond to a message received. If you do want to reply, furthermore, you do not need to use the same pipe. Check the status of the ...