Intermediate
22-9. | What is the maximum length of a pipe name? |
22-10. | Which of the following statements are true, and which are false?
|
22-11. | Write a block of code to create a private pipe named “national_security” with an initial size of 2 MB. |
22-12. | Why might you want to call DBMS_PIPE.RESET_BUFFER before packing your message for sending? |
22-13. | You send a message to a pipe as follows: DECLARE
stat INTEGER;
BEGIN
DBMS_PIPE.PACK_MESSAGE (SYSDATE);
stat := DBMS_PIPE.SEND_MESSAGE ('when');
END;But when you try to read the contents of the pipe with the following block, you get an error. What are you doing wrong? DECLARE
stat INTEGER;
BEGIN
stat := DBMS_PIPE.RECEIVE_MESSAGE ('when');
DBMS_PIPE.UNPACK_MESSAGE (stat);
END; |
22-14. | Write a block of code that sets up an infinite loop to receive a single numeric value from a pipe named “production”; specify that you are willing to wait up to 10 minutes for a message to appear in the pipe. If the message is not received successfully, display an ... |