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

    Oracle event based scheduling - JMS queue and parameters

      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.