"schw" <schwartz@alpha.net.pl> wrote in message
news:1156494426.258935.228940@i3g2000cwc.googlegro ups.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