create file problems with oracle [message #37008] |
Thu, 10 January 2002 01:03 |
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 #37013 is a reply to message #37008] |
Thu, 10 January 2002 01:54 |
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-
|
|
|
|