Hi All,
I m facing mentioned error while executing below code at line no 3.
CREATE or REPLACE DIRECTORY MY_DIR AS '/outputs/EXTRACTS';
GRANT READ,WRITE ON DIRECTORY MY_DIR TO public;
fileID := UTL_FILE.FOPEN('MY_DIR', fileName,'W');
I tried all the possibe ways but still not understood what is the problem there.
Please give ur sugeetions guys so i can try.
Thanks & Regards,
Bhushan
6 38094
Hi All,
I m facing mentioned error while executing below code at line no 3.
CREATE or REPLACE DIRECTORY MY_DIR AS '/outputs/EXTRACTS';
GRANT READ,WRITE ON DIRECTORY MY_DIR TO public;
fileID := UTL_FILE.FOPEN('MY_DIR', fileName,'W');
I tried all the possibe ways but still not understood what is the problem there.
Please give ur sugeetions guys so i can try.
Thanks & Regards,
Bhushan
ORA-29283
ORA-29283: invalid file operation
Cause: An attempt was made to read from a file or directory that does not exist, or file or directory access was denied by the operating system.
Action: Verify file and directory access privileges on the file system, and if reading, verify that the file exists.
ORA-29283
ORA-29283: invalid file operation
Cause: An attempt was made to read from a file or directory that does not exist, or file or directory access was denied by the operating system.
Action: Verify file and directory access privileges on the file system, and if reading, verify that the file exists.
thanks for the reply,
But i had got the same reply on google when i searched, i need some other solution guys.
Regds,
Bhushan
thanks for the reply,
But i had got the same reply on google when i searched, i need some other solution guys.
Regds,
Bhushan
Could you check if you have R,W,X permission on the directory ''/outputs/EXTRACTS''??
And CREATE DIRECTORY only creates a references object to the directory that you specidiy and not the directory itself.
Check whether the directory is present in the SERVER side and not Client Side and Oracle has permission ot write to it....
Use below Code to create the direcotry that u r using in yur code:
SQL> HOST MD'D:/tmp'
Could you check if you have R,W,X permission on the directory ''/outputs/EXTRACTS''??
And CREATE DIRECTORY only creates a references object to the directory that you specidiy and not the directory itself.
Check whether the directory is present in the SERVER side and not Client Side and Oracle has permission ot write to it....
Use below Code to create the direcotry that u r using in yur code:
SQL> HOST MD'D:/tmp'
Amit
Everything is fine about RWX u told still i m facing the same problem, i don't understanding what could be the problem. Is there any other reason bcoz of that OS dening on access by oracle
Regds,
Bhushan
Amit
Everything is fine about RWX u told still i m facing the same problem, i don't understanding what could be the problem. Is there any other reason bcoz of that OS dening on access by oracle
Regds,
Bhushan
Hi,
I tried the following steps which worked fine: -
-
create or replace directory my_dir AS '/tmp'
-
-
GRANT READ,WRITE ON DIRECTORY my_dir TO PUBLIC;
-
-
DECLARE
-
File UTL_FILE.FILE_TYPE;
-
BEGIN
-
File:= UTL_FILE.FOPEN('MY_DIR','a.txt','W');
-
UTL_FILE.PUT_LINE(File,'I am writing to file');
-
UTL_FILE.FCLOSE(File);
-
END;
-
/
-
The file a.txt was created and the content was written to the file perfectly.
When I tried creating directory to '/usr', and GRANT all required privileges. Then tried executing the above mentioned anonymous block. It failed, it said the same error as it is showing for your code. And I also tried ftp'ing a file to the folder '/usr' but permission denied. So the DBA have given privileges only to some USERS to make use of the folder '/usr' but '/tmp' can be accessed by anybody.
Hope this helps!!
Hi,
I tried the following steps which worked fine: -
-
create or replace directory my_dir AS '/tmp'
-
-
GRANT READ,WRITE ON DIRECTORY my_dir TO PUBLIC;
-
-
DECLARE
-
File UTL_FILE.FILE_TYPE;
-
BEGIN
-
File:= UTL_FILE.FOPEN('MY_DIR','a.txt','W');
-
UTL_FILE.PUT_LINE(File,'I am writing to file');
-
UTL_FILE.FCLOSE(File);
-
END;
-
/
-
The file a.txt was created and the content was written to the file perfectly.
When I tried creating directory to '/usr', and GRANT all required privileges. Then tried executing the above mentioned anonymous block. It failed, it said the same error as it is showing for your code. And I also tried ftp'ing a file to the folder '/usr' but permission denied. So the DBA have given privileges only to some USERS to make use of the folder '/usr' but '/tmp' can be accessed by anybody.
Hope this helps!!
yep, this one works!
thx for ur help, i've been searching for this for more that 5 hours!
OPEN SOURCE ROCKSSSS!!!!!!
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Galina |
last post by:
Hello
I have created a trigger not to let records with certain fields null
to be inserted into the table:
BEGIN
IF :new.RUL_CODE is null or
:new.FES_UINS_CODE is null or
:new.FES_UIO_CALOCC is...
|
by: Cherrish Vaidiyan |
last post by:
Hello all,
A warm Xmas greetings to all. I have a small problem with starting up
the database. Here my strategy.
I have installed Oracle 9i R 2 on Red Hat 9. i created two database on
this...
|
by: Brett Baloun |
last post by:
Hello,
I received this error message when I issue the drop statement. We are
using a 9.2.0.3 DB on UNIX OS. I have been able to drop other users
within the same session, but this particular...
|
by: Paul Green |
last post by:
What might cause the following behavior?
We have a set of front-end programs accessing an Oracle database on
the server.
Things work fine on our older computers and mostly OK on our new
computers...
|
by: J.Bijleveld |
last post by:
Hello colleagues,
At this moment we have a real big problem using a .NET application with an
Oracle database (v8.1.6).
I hope someone has encountered this problem before and is able to help me...
|
by: J.Bijleveld |
last post by:
Hello colleagues,
At this moment we have a real big problem using a .NET application
with an Oracle database (v8.1.6). I hope someone has encountered this
problem before and is able to help me...
|
by: smita81 |
last post by:
Hi,
I have a problem while trying to login to toad.
My operating system is WINDOWS XP.
I have Oracle 9i at my system. I installed the Toad into the system.When I start the Toad "Toad Server...
|
by: hemantmudaliar |
last post by:
The Trigger is giving following exception
java.sql.SQLException: ORA-04091: table PSCONTENT.VGNASCHANNEL is mutating, trigger/function may not see it ORA-06512: at...
|
by: Nitvar |
last post by:
When i am trying to connect to oracle it is giving me these two errors
ORA-12224: TNS:no listener
ORA-01034: ORACLE not available
I am new to oracle ,plz help
I am using solaris 5.6 and...
|
by: nabh4u |
last post by:
HI everyone,
I an getting the following errors when i execute my procedure.
SQL> exec PROCEDURE_NAME
BEGIN PROCEDURE_NAME; END;
*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error:...
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
| |