1.2 use the CREATE DIRECTORY feature instead of UTL_FILE_DIR for directory access verification.
2.Up to 8i, Oracle refused to access a file that is not pointed to in the utl_file_dir parameter in
the init
In Oracle 9i, in order to access a file, either the utl_file_dir parameter must be set, or one has to create a directory.
3.First Availability
Oracle Version : 7.3.4
4.The UTL_FILE package is similar to the client-side TEXT_IO package currently provided by Oracle Procedure Builder. Restrictions for a server implementation require some API differences between UTL_FILE and TEXT_IO. In PL/SQL file I/O, errors are returned using PL/SQL exceptions.
5.Open Mode.
1.A append
2.R read
3.W write
No comments:
Post a Comment