posted 12 years ago
DECLARE
fileID UTL_FILE.FILE_TYPE;
strbuffer VARCHAR2(100);
firstTen VARCHAR2(10);
BEGIN
fileID := UTL_FILE.FOPEN ('D:\srikanth.txt', 'srikanth.txt', 'R');
UTL_FILE.GET_LINE (fileID, strbuffer);
UTL_FILE.FCLOSE(fileID);
END;
Gives the following error.
=================
Error starting at line 25 in command:
DECLARE
fileID UTL_FILE.FILE_TYPE;
strbuffer VARCHAR2(100);
firstTen VARCHAR2(10);
BEGIN
fileID := UTL_FILE.FOPEN ('D:\srikanth.txt', 'srikanth.txt', 'R');
UTL_FILE.GET_LINE (fileID, strbuffer);
UTL_FILE.FCLOSE(fileID);
END;
Error report:
ORA-29280: invalid directory path
ORA-06512: at "SYS.UTL_FILE", line 29
ORA-06512: at "SYS.UTL_FILE", line 448
ORA-06512: at line 6
29280. 00000 - "invalid directory path"
*Cause: A corresponding directory object does not exist.
*Action: Correct the directory object parameter, or create a corresponding
directory object with the CREATE DIRECTORY command.