Home     |     Java    |     Php General    |     Oracle Database    |     Oracle Server  

MS Dynamics CRM 3.0

  •  Setting up and Configuring Microsoft Dynamics CRM 3.0
  •  Managing Security and Information Access
  •  Entity Customization: Concepts and Attributes
  •  Entity Customization: Forms and Views
  •  Entity Customization: Relationships, Custom Entities, and Site Map
  •  Reporting and Analysis
  •  Workflow
  •  Server-Side SDK
  •  Client-Side SDK
  •  Integration with External Applications

    • Cervo Technologies
    The Right Source to Outsource

    Sharepoint Portal Server KB

    Microsoft CRM Info

    WPF Interview Questions

    SilverLight Interview Qs

    Asp.Net 2.0 Interview Qs

    Asp.NET 1.1 FAQs

    Oracle Interview Questions

    SAP Interview Questions

    Oracle Server

    DBMS_PIPE


    How do I check the number of messages that are in a pipe? I would like
    to stop sending messages to the pipe if the number of messages exceeds
    a certain number.

    Thank you in advance for any response.

    Regards,
    z1hou1

    As far as I know the dbms_pipe package doesn't offer any facility to
    find out the number of messages within a pipe. At least you can
    maintain a counter by yourself into a table incrementing it when a new
    message is put into the pipe and decrement it when the message is
    extracted from within the same pipe.

    Regards,
    talek

    On May 11, 3:00 pm, z1h@gmail.com wrote:

    > How do I check the number of messages that are in a pipe? I would like
    > to stop sending messages to the pipe if the number of messages exceeds
    > a certain number.

    > Thank you in advance for any response.

    > Regards,
    > z1hou1

    I don't know much about it, but looking at the docs it seems there is
    a maxpipesize parameter when you create the pipe, and you will be
    blocked when the pipe is full.  So stop sending when you are blocked.

    jg
    --
    @home.com is bogus.
    "stupid_query_detection=off | normal | aggressive | facist" - Andre

    -----------------------------------------------Reply-----------------------------------------------

    Thank you all for your suggestions. A combination of the above should
    help me with this issue. I was looking for something other than AQ
    since AQ was an overkill for my requirement.

    Regards,
    z1hou1

    -----------------------------------------------Reply-----------------------------------------------

    z1h@gmail.com wrote:
    > Thank you all for your suggestions. A combination of the above should
    > help me with this issue. I was looking for something other than AQ
    > since AQ was an overkill for my requirement.

    > Regards,
    > z1hou1

    AQ may be overkill but building an AQ implementation shouldn't take
    more than a day-or-two. Why not leverage the capabilities?
    --
    Daniel A. Morgan
    University of Washington
    damor@x.washington.edu
    (replace x with u to respond)
    Puget Sound Oracle Users Group
    www.psoug.org
    Add to del.icio.us | Digg this | Stumble it | Powered by Megasolutions Inc