Oracle input connector

View: New views

2 Messages — Rating Filter: Alert me

Oracle input connector

by DanyLux :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hello everybody,

I just wanted to ask if it is possible to make in mule an oracle db listener connector, that will listen on the db if there is a new entry and then catch that information and just send it forward in a mail when the same information will not been added to the db after a given minutes.

Many thanks in advance for your answer.
Dany

Re: Oracle input connector

by MikeJC :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

How about creating a trigger on the table, when an insert occurs (before/after) drop a message to Oracle AQ. You can then setup Mule to listen on Oracle AQ and do whatever you want with the message.

DanyLux wrote:

Hello everybody,

I just wanted to ask if it is possible to make in mule an oracle db listener
connector, that will listen on the db if there is a new entry and then catch
that information and just send it forward in a mail when the same
information will not been added to the db after a given minutes.

Many thanks in advance for your answer.
Dany