weirdness with UTL_FILE.FOPEN

running in sql++ ORACLE v 10.2.0.5

login as BT

----------------------------------

CREATE OR REPLACE DIRECTORY  TXT_SRCH AS '/home/oracle/TSI';

GRANT READ, WRITE ON DIRECTORY TXT_SRCH TO BT;

-----------------------------------------------------------------------------------------------------------

my code:

------------------------------------------------------------------------------------------------

--DECLARE

CREATE OR REPLACE FUNCTION WRITE_TXTS_CSV(XFNO IN INTEGER) RETURN VARCHAR2 IS

  TS_START     TIMESTAMP(6);

  XFNO       INTEGER := 8;

  RET        VARCHAR2(50) := NULL;

  OUT_STR      VARCHAR2(1000);

  FILE_HNDL     UTL_FILE.FILE_TYPE;

  DIFF       NUMBER := 0;

  RCNT       NUMBER := 0;

  CNTRL_REC_NO   NUMBER := 0;

  FILE_NAME     VARCHAR2(500) := 'txtsrch_upload-' || TO_CHAR(XFNO) || '.csv';

  XRID       VARCHAR2(100);

  sTMP       VARCHAR2(2000);

  CURSOR C1 IS

    SELECT XSTR || CHR(13) || CHR(10) AS STR_OUT

     FROM WEB4TP.TXTS_CSV