Communication Between Session!!

[mamfaizi]

Is It possible to have a Intersession Communication between two oracle Session/User?

[Dave_A]

Check out the DBMS_PIPE package, this deals with inter-process communication.

HTH.

David.

[aracnid]

for dave_a:
Can you bee more explicit please.....how is the using of dbms_pipe package?
...have to install something?

[Dave_A]

To describe the DBMS_PIPE package in any detail here would take far too long - I intended the post to be a pointer as to what you needed to look up in the manuals.

The package contains the following functions and procedures:

create_pipe
next_item_type
pack_message
receive_message
remove_pipe
reset_buffer
send_message
unique_session_name
and
unpack_message

Any of the PL/SQL programming guides should be able to give you the information that you need.

HTH

David.

[LND]

note usage of dbms_pipe.reset_buffer:
call it every time before packing new message to send with dbms_pipe.send_message.
The issue is to clear buffer before making new message since buffer can be not empty because of misssed or failed call to receive_message.