Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

utl_file issue

979078Jan 9 2013 — edited Jan 10 2013
utl_file autoflush or utl_file.fflush creates a empty text/log file. The text/log file is filled only when the Oracle Scheduler job completes with all the utl_file.put_line messages.

Oracle Scheduler job executes a PL/SQL procedure which uses the utl_file to create a log file for the job run at the OS level.

I used both utl_file.put_line autoflush and utl_file.fflush but still the the first utl_file.put_line message is not written to the log file. The log file is created but it is empty. All the utl_file.put_line messages are written to the log file only when the Oracle Scheduler job completes.

This is Oracle 11g R2 Exadata on Linux.

Thanks!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 7 2013
Added on Jan 9 2013
#11g, #database, #exadata, #oracle, #performance-availability
2 comments
731 views