This discussion is archived
10 Replies Latest reply: Sep 6, 2012 11:34 AM by user3982832 RSS

Oracle event based scheduling - JMS queue and parameters

user3982832 Explorer
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points