4 Replies Latest reply on Oct 5, 2012 11:24 AM by AnkitV

    UTL_FILE.PUT_LINE   not writing to file in real time !!!

      Hi All

      I have 3 statements and I am writing some thing to a file using UTL_FILE.PUT_LINE after each statement is over. Each statement takes mentioned time to complete.
      I am opening file in append mode.

      statement1 (takes 2 mins)

      statement2 (takes 5 mins)

      statement3 (takes 10 mins)

      I noticed that I am able to see contents written by UTL_FILE.PUT_LINE only after statement3 is over, not IMMEDIATELY after statement1 and statement2 are done ?
      Can anybody tell me if this is correct behavior or am I missing something here ?

      Thanks a lot in advance.