Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Issue with UTL_FILE

User_OX73AMay 19 2021 — edited May 19 2021

My DB details
Oracle Database 11g Release 11.2.0.4.0 - 64bit Production
When I am trying to run the below script using SQL developer, it is throwing the below error
Script:

declare
F_LOG utl_file.file_type;
begin
F_LOG := utl_file.fopen('/ppskw/anw/etiketten','y123', 'W');
end;

The parameter is already being set in the DB
image.pngError :
image.pngHowever, when I am running the same script directly on the server ( using putty) it is working fine
Any suggestion or comment is appreciated.

Comments
Post Details
Added on May 19 2021
2 comments
140 views