image

CHAPTER3

utl_file Package

Purpose

This chapter teaches you how to configure, deploy, manage, and troubleshoot the utl_file package. The utl_file package was introduced in Oracle version 7 as a PL/SQL tool to sequentially read files from and write files to the operating system. Oracle9i Database added limited ability to randomly read files by shifting the pointer forward or backward through a file. Oracle Database 10g enabled the utl_file package to use virtual directories rather than physical path locations. Oracle Database 10g also removed the physical limitation on writing external files through the dbms_output package. There are no changes ...

Get Oracle Database 12c PL/SQL Advanced Programming Techniques now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.