problem with UTL_FILE package

Hello,

I've got a problem with the UTL_FILE package. I have 3 machines, all running Oracle
Workgroup Server 7.3.2.2.1, 2 machines with Windows NT Server SP4 and 1 machine with Windows NT Workstation Sp4 (the "problem child").

I use this procedure (in a package):

procedure WriteLog(cInfo char)
is
  fHandle UTL_FILE.FILE_TYPE;
  cInfo2 char(250);
  cLogDate char(8);
begin
  cInfo2 := to_char(sysdate,'DD.MM.YYYY hh24:mi:ss') || ' ' || cInfo;   cLogDate := to_char(sysdate,'YYYYMMDD');   begin

• open logfile in append mode fHandle := UTL_FILE.FOPEN(cLogPath, cLogDate || cLogFile, 'a'); exception
• on exception create file in write mode when UTL_FILE.invalid_operation or UTL_FILE.invalid_mode or UTL_FILE.invalid_path then fHandle := UTL_FILE.FOPEN(cLogPath, cLogDate || cLogFile, 'w'); end; UTL_FILE.PUT_LINE(fHandle, mbt.Atrim(cInfo2)); UTL_FILE.FCLOSE(fHandle); end WriteLog;

  ---

The logfile is generated with the actual date (YYYYMMDD.log). Entries should be
appended to the log if the file exists. If it doesn't exist, a new file should be created.

My problem:

On the 2 NT Servers this procedure works fine, on the Workstation an error message
comes up: "ORA-03113 end-of-file on communication channel."

If the log exists, the procedure works fine, if the procedure opens always in write mode,
it also works (but always overwrites the previous entries).

Does anyone have a suggestion about this problem?

Any help is appreciated.

Bye

Michael Received on Mon Aug 02 1999 - 08:08:33 CDT