<div>
if the file is not availale on the same machine where your database is, then utl_file will not be able to read that. you need to check where your text file is and the solution depends on that.
</div>


if the file is not availale on the same machine where your database is, then utl_file will not be able to read that. you need to check where your text file is and the solution depends on that.

<div>
My TXT file is located on the database server. The user has a shortcut to the directory and they place the file in there there. I also create an oracle directory to point to it.
</div>


My TXT file is located on the database server. The user has a shortcut to the directory and they place the file in there there. I also create an oracle directory to point to it.

<div>
I am not an expert in forms, however I know that you can use stored proc in forms, and if your file is on the server, you can effectively use it to load data in a table. If you want to see the examples of how to use utl_file, check following link:<br />
<a href="http://psoug.org/reference/utl_file.html" rel="ugc">http://psoug.org/reference/utl_file.html</a>
</div>


I am not an expert in forms, however I know that you can use stored proc in forms, and if your file is on the server, you can effectively use it to load data in a table. If you want to see the examples of how to use utl_file, check following link:
http://psoug.org/reference/utl_file.html [http://psoug.org/reference/utl_file.html]

<div>
<div class="content wysiwyg-content">
I have a TXT file that resides on a desktop. A 10g Form reads that text file and populates a database table.<br />
<br />
I suspect that I need to use CLIENT_TEXT_IO rather than UTIL_FILE.<br />
<br />
Can anyone confirm this and also provide a link to CLIENT_TEXT_IO 
</div>
</div>


I have a TXT file that resides on a desktop. A 10g Form reads that text file and populates a database table.

I suspect that I need to use CLIENT_TEXT_IO rather than UTIL_FILE.

Can anyone confirm this and also provide a link to CLIENT_TEXT_IO 

ORacle 10g- Client_text_io

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.