UTL_FILE_DIR path test
- Posted by Arjun Raja
- On July 10, 2009
- 0 Comments
To test if the utl_file_dir path in the init.ora file can indeed be written to . Login as sysdba – 1. Create a test procedure CREATE OR REPLACE procedure utl_file_test_write ( path in varchar2, filename in varchar2, firstline in varchar2, secondline in varchar2) is output_file utl_file.file_type; begin output_file := utl_file.fopen (path,filename, ‘W’); utl_file.put_line (output_file, firstline); […]
Read More