Re: UTL_TCP, Oracle, java

"schw" <schwartz_at_alpha.net.pl> wrote in message news:1156494426.258935.228940_at_i3g2000cwc.googlegroups.com...
> Hi All,
>
> basically I've got a java server listening on specified port; within
> Oracle triggers I use UTL_TCP package to send columns data that changed
> to the server.
>
> is there any other than UTL_TCP used within oracle triggers solution to
> talk to Java deamon?
>
> before i start implementing i'd like to find out other alternatives.
>
> thanks
>
> best regards
> schw
>

You want to be careful. The way you propose to implement you will passon data that may not exist. For example,
insert x data
utl_tcp sends data
client issues rollback;
now you are out of synch.

Instead wrap the ult_tcp into a package and call dbms_job to run once immediately. The dbms_job won't run if there is a rollback only if there is a commit. (see asktom.oracle.com)
Jim Received on Fri Aug 25 2006 - 09:32:56 CDT