ORA-29285: file write error

Question

Dear ALL,

I am passing data of length

t_clob_len

2368607

NUMBER(38,0)

to the following procedure.

t_clob_len := DBMS_LOB.GetLength(p_data);

        t_out_file := UTL_FILE.fOpen(p_dir,p_file, 'A', 32767);
        LOOP
            DBMS_LOB.Read(p_data,t_amount,t_pos, t_buffer);
            Utl_File.Put(T_Out_File, T_Buffer);
            
            Utl_File.Fflush(T_Out_File);

            t_pos := t_pos + t_amount;
            IF t_clob_len<=t_pos THEN
                exit;
            END IF;
        END LOOP;

  UTL_FILE.fClose(t_out_file);

But i am getting following error at Utl_File.Fflush(T_Out_File); Method while looping at 3rd time .

error:=ORA-29285: file write error

Please Suggest any Solution.

Answer 1

Here's another way of doing it:

      int i = 1;

      int j = 2;

      i ^= j;

      j ^= i;

      i ^= j;

      Console.WriteLine("i = {0}, j = {1}", i, j);

Answer 2

  Something like this, try it..

            int i = 1;

            int j = 2;

            Console.WriteLine("i = " + i);

            Console.WriteLine("j = " + j);

            i = (j + i);

            j = (i - j);

            i = (i - j);

            Console.WriteLine("");

            Console.WriteLine("i = " + i);

            Console.WriteLine("j = " + j);

            Console.ReadKey();