79094952

Date: 2024-10-16 16:24:08
Score: 1.5
Natty:
Report link

Can you run this to check the files under directory ? Replace MY_DIR using your directory name

Code:

DECLARE
  l_file_handle UTL_FILE.FILE_TYPE;
  l_file_name VARCHAR2(255);
  l_is_dir BOOLEAN;
BEGIN
  l_file_handle := UTL_FILE.FOPEN('MY_DIR', '.');
  LOOP
    UTL_FILE.GET_LINE(l_file_handle, l_file_name);
    DBMS_OUTPUT.PUT_LINE(l_file_name);
  END LOOP;
EXCEPTION
  WHEN NO_DATA_FOUND THEN
    UTL_FILE.FCLOSE(l_file_handle);
END;
Reasons:
  • Has code block (-0.5):
  • Contains question mark (0.5):
  • Starts with a question (0.5): Can you
  • Low reputation (1):
Posted by: munsidd