Re: Publishing to MQ

Hi all,

THanks.

Is there any way that when a row is being updated, I can invoke a Java program ( akind of rowlistener), without "triggers" ? Thanks

Best
Ravion

"Ravion" <ravishankar_at_singnet.com.sg> wrote in message news:futt1v$cs9$1_at_mawar.singnet.com.sg...
> Dear all.
>
> I have huge number of data coming to my application through a bacth
> process in main frame. Assuming that all this data are available in one
> table, I have a PL/SQL procedure to manipulate the data and do some data
> massaging and put into three tables.
>
> There is a second procedure which processes the rows of these three
> tables, and while the processing is going on, there can be some updates
> coming to these tables through an online application. ( Note that we are
> processing the data got from a bacth. Now we have some rows which are
> coming to this table directly from internet i.e online)
>
> THere is a Java Rule Engine waiting to process the output of the above
> batch. Now my question is how PL SQL can inform Java that the bacth
> processing is complete. This is because Java program will never know when
> PL SQL batch completed its work, and while PL SQL is doing the batch,
> there can be some more rows coming for it to process through online.
>
>
> Is there any event pusblish mechanism i.e JMS way by which PL SQL can
> notify Java that the processing is complete by putting a message into
> queue? I dont want to go for triggers. Please advise the best design
> possible, thanks a million.
>
> Best, Ravion
>
Received on Sat Apr 26 2008 - 19:32:14 CDT