Is It possible to have a Intersession Communication between two oracle Session/User?
Printable View
Is It possible to have a Intersession Communication between two oracle Session/User?
Check out the DBMS_PIPE package, this deals with inter-process communication.
HTH.
David.
for dave_a:
Can you bee more explicit please.....how is the using of dbms_pipe package?
...have to install something?
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.
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.