Linux Operating System (MOSC)

MOSC Banner

Samba Mount issue

edited Oct 17, 2010 12:59PM in Linux Operating System (MOSC) 2 commentsAnswered
 Hi ,

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');

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center