Link to home
Start Free TrialLog in
Avatar of Satish Valekar
Satish ValekarFlag for India

asked on

while writing excel file using oracle plsql onto other machine in windows server getting error as invalid file operation?

create or replace directory authfile_test as '\\172:17:89:82\authfile';
I used this directory in my plsql procedure to write excel file on this machine.

Please note that, operating system is windows and 172:17:89:82 is another machine.
but while excution  getting error invalid file operation.

I tried the same thing on same server and succeed to generate file without any error, but whilw trying to create file onto aother server i got  above error.

Please tell me, is there any network setting or permission need to give to solve this problem.
can we create directory with ip address of another  machine ?
for example \\172:17:89:82\authfile';
Please provide sample example and how to give all rights to write file at other machine not at oracle database server.
ASKER CERTIFIED SOLUTION
Avatar of MarkusId
MarkusId
Flag of Austria image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial