Samba Mount issue
We are using 10.2.0.4 database with Oracle E-Buisness 11.5.10
We have a samba mount presented on both db tier and Apps tier
I am able to create a file in db tier but not from apps tier
The error i am getting is
SQL> @test.sql
17 /
Others -29283 ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE",
line 537
ORA-29283: invalid file operation
PL/SQL procedure successfully completed.
test.sql has ,
set serveroutput on
DECLARE
file_location VARCHAR2(256) := 'OHIS_INTERF_DIR_OUT';
file_name VARCHAR2(256) := 'utlfile1.lst';
file_text VARCHAR2(256) := 'THIS IS A TEST';
file_id UTL_FILE.file_type;
BEGIN
file_id := UTL_FILE.fopen(file_Location, file_name, 'W');