This discussion is archived
4 Replies Latest reply: Oct 5, 2012 4:24 AM by AnkitV RSS

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

AnkitV Newbie
Currently Being Moderated
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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points