10 Replies Latest reply: Sep 6, 2012 1:34 PM by user3982832 RSS

    Oracle event based scheduling - JMS queue and parameters

    user3982832
      Hello – I need to trigger execution of stored procedure using event based scheduling. Here the scenario...

      1. Siebel application submits the Order

      2. The Order Id and XML Payload is inserted in Oracle JMS queue (In COORID and USER_DATA respectively)

      Now I need to trigger Oracle stored procedure and pass Order Id and XML message as parameters to the procedure

      How can I do that?

      Appreciate any help.

      Thanks