UTL_FILE_DIR path test

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); […]