4 Replies Latest reply: Oct 5, 2012 6:24 AM by AnkitV RSS

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

    AnkitV
      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)
      UTL_FILE.PUT_LINE

      statement2 (takes 5 mins)
      UTL_FILE.PUT_LINE

      statement3 (takes 10 mins)
      UTL_FILE.PUT_LINE

      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.