Help on UTL_FILE package

[Jeronimo]

Hi everybody,<br>I have a problem using the procedure UTL_FILE.GET_LINE.<br>My ORACLE version is 8i. Here's the problem:<br>I want to open a textfile which contains several lines; it looks like this:<br>item1 item2 item3 <br>item4 item5 item6 <br>item7 item8 item9 <br><br>I want to store the items in different tables. Therefore,<br>I first open the file: <br>fileHandler := UTL_FILE.FOPEN(location, textfile, 'r').<br>Then, I use UTL_FILE.GET_LINE(fileHandler, outbuf).<br>But outbuf will only contain the first line, that is <br>'item1 item2 item3'. How can I access the other lines?<br>Many thanks for your help!<br>Cheers,<br>Dan

 

[MikeLacey]

Hi Dan,<br><br>Forgive me if I've misunderstood your post but -- I think you'll find get just the one line for each call to GET_LINE, so to get the next line, call it again.<br> <p>Mike<br><a href=mailto:michael.j.lacey@ntlworld.com>michael.j.lacey@ntlworld.com</a><br><a href=

http://www.cargill.com/>

Cargill's Corporate Web Site</a><br>

 

[carp]

Mike -
I read the question the same way and come to the same response.

 

[MikeLacey]

Carp -- long time no see <smile>

 

[carp]

Mike -
It's nice to be back! I had to start working for a living again, and hadn't had much time for anything else (not to mention the return of fishing and hunting seasons!).