Home » SQL & PL/SQL » SQL & PL/SQL » create file problems with oracle
create file problems with oracle [message #37008] Thu, 10 January 2002 01:03 Go to next message
fionan
Messages: 5
Registered: January 2002
Junior Member
hi,
i have created a procedure that creates a new file in a directory i specify in utl_file but when i run the procedure it is giving me the exception invalid operation.This happens when it trys to open the file on the path i specified.I was wondering is there any additional changes you have to make other then specifying the path in the init.ora file.It seems the procedure code is right but there is a problem with the init.ora i am running oracle 8i
any ideas appreciated
Re: create file problems with oracle [message #37011 is a reply to message #37008] Thu, 10 January 2002 01:27 Go to previous messageGo to next message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
Hi,

just run this query and make sure utl_file_dir is set properly:-
select name,value from
sys.v$parameter where upper(name)='UTL_FILE_DIR';

cheers
pratap
Re: create file problems with oracle [message #37013 is a reply to message #37008] Thu, 10 January 2002 01:54 Go to previous messageGo to next message
Manish
Messages: 79
Registered: December 2000
Member
Hello Pratap:
The query (select name,value from sys.v$parameter where upper(name)='UTL_FILE_DIR') gives the following error:
ERROR at line 1:
ORA-00942: table or view does not exist
What could be wrong?
-mb-
Re: create file problems with oracle [message #37020 is a reply to message #37008] Thu, 10 January 2002 08:13 Go to previous message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
set utl_file_dir parameter with directory you want to read before executing pl/sql code
Previous Topic: ole2 not declared
Next Topic: error
Goto Forum:
  


Current Time: Thu Aug 06 08:45:00 CDT 2020