Replacing PL SQL with Java

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.

My questions are:-

1) Since millions of rows are processed through the PL/SQL in less time, is
it advisable to replace it by Java ?

2) If I use PL SQL, can it publish a message to queue, saying the Java
counterpart that the processing is complete by the PLSQL procedure?

3) WHat can be the alternates?

Best, Ravi


.

Relevant Pages

  • Publishing to MQ
    ... I have huge number of data coming to my application through a bacth process ... THere is a Java Rule Engine waiting to process the output of the above ... SQL batch completed its work, and while PL SQL is doing the batch, there can ...
    (comp.databases.oracle.server)
  • Re: Publishing to MQ
    ... What did you mean by "back channel", ... THere is a Java Rule Engine waiting to process the output of the above ... PL SQL batch completed its work, and while PL SQL is doing the batch, ...
    (comp.databases.oracle.server)
  • Re: Publishing to MQ
    ... 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. ... 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. ...
    (comp.databases.oracle.server)
  • Re: Publishing to MQ
    ... Is there any way that when a row is being updated, I can invoke a Java ... PL SQL batch completed its work, and while PL SQL is doing the batch, ... I dont want to go for triggers. ...
    (comp.databases.oracle.server)
  • Re: use of DBI; I am getting multiple error messages mixed in with the correct output.
    ... Perl was to relate it to uninitialized values in Java or C++. ... The fact that nulls in SQL have special ... Both Java and C++ have containers that support set theoretic ...
    (comp.lang.perl.misc)