1 Reply Latest reply on Jun 21, 2013 11:07 PM by 5de0a0b4-708f-4f61-abd3-fc4ed9fe6e00

    MATCH_RECOGNIZE Pattern with more than one eventType

    5de0a0b4-708f-4f61-abd3-fc4ed9fe6e00

      Hello

       

      i try to make a query in Oracle CQL, which should detect an event (eg. price event) followed by an other event (NOT a price event; eg. inventoryEvent).

      I used Esper before.

      Here is a short example: (eql)

       

                  insert into somethingEvent
                      select p.id, p.price, s.size
                      from pattern[
                          every p= priceEvent(p.price<getGoodPrice())
                          -> i=inventoryEvent(i.id = p.id)
                      ]

       

      I didnt find a similiar way to do this in Oracle CEP. I only found patterns using MATCH_RECOGNIZE and i dont know how to match more than one event Type.

      Also is there a way to create new (other) events within the Rule? (after fireing) (like the INSERT INTO statement in esper)

       

      I hope u guys can help me.

      greetz Trinity