Home » SQL & PL/SQL » SQL & PL/SQL » UTIL File Error (9i in Unix)
UTIL File Error [message #289508] Sun, 23 December 2007 00:09 Go to next message
Messages: 1
Registered: December 2007
Location: Bangalore
Junior Member
hi All,

I am trying to read a file in my PL/SQL Program, it opens the File and reading first two lines but after that suddenly goes to the Exception part (invalid File_type). Pl tell me how to resolve this Problem.
File is being opened as below-

vInHandle := utl_file.fopen('ORALOAD', 'test.txt', 'R', 3000);

Re: UTIL File Error [message #289509 is a reply to message #289508] Sun, 23 December 2007 00:18 Go to previous messageGo to next message
Messages: 25578
Registered: January 2009
Location: SoCal
Senior Member
You do not follow posting guidelines:
You have have source code & you do no post code that fails & expect us to debug your unseen source code. WHY?
Since you do not know the answer. Why do you expect us to have any answer?

Can YOU debug code you can not see?????????????????

I can not debug unseen code & it appears you can not debug code you can see.
Re: UTIL File Error [message #289512 is a reply to message #289508] Sun, 23 December 2007 00:39 Go to previous message
Michel Cadot
Messages: 65153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
In addition copy and paste the execution with error message.
"invalid file type" is not in the exceptions listed in utl_file documantation http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/u_file.htm#i996873.

Previous Topic: Problem of ORA-00942
Next Topic: Group by clause
Goto Forum:

Current Time: Tue Aug 22 19:40:22 CDT 2017

Total time taken to generate the page: 0.05283 seconds