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.
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:
Any of the PL/SQL programming guides should be able to give you the information that you need.
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.
Click Here to Expand Forum to Full Width