Take the 2-minute tour ×  I'm considering using a Java stored
procedure as a very small shim to allow UDP communication from a
PL/SQL package. Oracle does not provide a UTL_UDP to match its
UTL_TCP. There is a 3rd party XUTL_UDP that uses Java, but it's
closed source (meaning I can't see how it's implemented, not
that I don't want to use closed source).  An important
distinction between PL/SQL and Java stored procedures with
regards to networking: PL/SQL sockets are closed when
dbms_session.reset_package is called, but Java sockets are not.
So if you want to keep a socket open to avoid the tear-
down/reconnect costs, you can't do it in sessions that are using
reset_package (like mod_plsql or mod_owa HTTP requests).  I
haven't used Java stored procedures in a production capacity in
Oracle before. This is a very large, heavily-used database, and
this particular shim would be heavily used as well (it serves as
a UDP bridge between a PL/SQL RFC 5424 syslog client and the
local rsyslog daemon).  Am I opening myself