Communication Between Session!!
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Communication Between Session!!

  1. #1
    Join Date
    Mar 2001
    Posts
    6
    Is It possible to have a Intersession Communication between two oracle Session/User?

  2. #2
    Join Date
    Feb 2001
    Posts
    123
    Check out the DBMS_PIPE package, this deals with inter-process communication.

    HTH.

    David.

  3. #3
    Join Date
    Apr 2000
    Location
    roma
    Posts
    131
    for dave_a:
    Can you bee more explicit please.....how is the using of dbms_pipe package?
    ...have to install something?

  4. #4
    Join Date
    Feb 2001
    Posts
    123
    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.

  5. #5
    Join Date
    Nov 2000
    Posts
    212
    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
  •  



Click Here to Expand Forum to Full Width