-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|