SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

utl_file.fopen() gives "ORA-29284: file read error" for MS Word doc

barqFeb 27 2010 — edited Mar 10 2010

I have two files in the same folder and having the same rights. One file is pdf and the other one is MS Word. These files are stored in a linux server. I can open the pdf file with utl_file.fopen() but can't open Word file. It gives me error ORA-29284 file read error. I can access the MS Word file through oracle text query using "contains" expression. But I want to get a particular string value from that file thats why I have to use utl_file.fopen() and utl_file.get_line() functions.
Is there any issue in accessing MS Word file stored in linux through oracle function? Any help would be appreciated.

Thanks and regards.

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 7 2010

Added on Feb 27 2010

#database, #pl-sql, #sql

15 comments

6,077 views