Which built-in package is used for intersession communication?

Options
- DBMS_OUT
- DBMS_OUTPUT
- DBMS_PUT
- DBMS_PIPE

CORRECT ANSWER : DBMS_PIPE

Discussion Board
DBMS_PIPE

The DBMS_PIPE package provides services that allow Oracle sessions connected to the same instance to communicate messages with each other without the need for a COMMIT. Sessions use DBMS_PIPE programs to pack data into a message buffer and then send the message to a memory area in the Oracle shared pool (the pipe ), where another session can receive it and unpack the message data into local variables.

Prajakta Pandit 02-21-2017 11:21 PM

Write your comments


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Related Content

Advertisement
 
▲