RE: [Log4plsql] (no subject)

[<log...@li...>]

Hi Seth.

Because it turns out that the Oracle VM closed all open file handles (and
also sockets) on purpose when the method call finishes even though static
objects that could survive the call were used. Oracle explains that this is
by design and documented in the section "Operating System Resources Affected
Across Calls" at
http://technet.oracle.com/doc/oracle8i_816/java.816/a81353/03writed.htm.

A major drawback with Java stored procedures :-(.

HTH.

Finn

---------------------------------------------------------------------------
 Finn Ellebaek Nielsen                           ChangeGroup ApS
 Product Manager, Principal Consultant, Partner  Kronprinsessegade 54, 4.
 E-mail: fe...@ch...                      DK-1306  Koebenhavn K
 Mobile: +45 20 32 49 25                         Denmark
 Phone:  +45 33 32 77 78                         http://www.changegroup.dk
---------------------------------------------------------------------------
                      "Where do you want to GPF today?"
-----Original Message-----
From: log...@li...
[mailto:log...@li...]
Sent: Friday, 8 November, 2002 00:05
To: log...@li...
Subject: [Log4plsql] (no subject)


Guillaume,

Forgive me if I'm asking a stupid question, but why did you use dbms_pipe to
create log4plsql rather than just creating java stored procedures in the
database that supported all the log4j functionality and wrote to a file
outside the db?


Sincerely,


Seth Gelberg
*************

View all problems as challenges. Look upon negativities that arise as
opportunities to learn and to grow. Don't run from them, condemn yourself,
or bury your burden in saintly silence. You have a problem? Great. More
grist for the mill. Rejoice, dive in, and investigate.

-Bhante Henepola Gunaratana, "Mindfulness in Plain English"