Skip to Main Content

Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

LFI-Error (1509)

user3492700Jan 17 2024

Hello,

OS: Windows Server 2019
Oracle Database: 21c Express Edition

I created a procedure to read a file.

CREATE OR REPLACE PROCEDURE PROCEDURE1 AS
fhandle UTL_FILE.FILE_TYPE;

begin
fhandle:= UTL_FILE.FOPEN('EXP1','Report.txt','R');
UTL_FILE.FCLOSE(fhandle);
END PROCEDURE1;

EXP1 ist a directory pointing to a network share, the file exists.

Read access has been granted to the database user.

The OracleXEService is running with a domain user which has access to this network share.

When I execute the procedure i get following errors:

ORA-29283: Ung├╝ltiger Dateivorgang : Unerwarteter "LFI"-Fehler (1509)[29437]
ORA-06512: in "SYS.UTL_FILE", Zeile 536
ORA-06512: in "SYS.UTL_FILE", Zeile 41
ORA-06512: in "SYS.UTL_FILE", Zeile 478
ORA-06512: in "CLC.PROCEDURE1", Zeile 12
ORA-06512: in Zeile 2

Comments
Post Details
Added on Jan 17 2024
0 comments
68 views