Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Help on UTL_FILE package

Help on UTL_FILE package

Help on UTL_FILE package

Hi everybody,
I have a problem using the procedure UTL_FILE.GET_LINE.
My ORACLE version is 8i. Here's the problem:
I want to open a textfile which contains several lines; it looks like this:
item1 item2 item3
item4 item5 item6
item7 item8 item9

I want to store the items in different tables. Therefore,
I first open the file:
fileHandler := UTL_FILE.FOPEN(location, textfile, 'r').
Then, I use UTL_FILE.GET_LINE(fileHandler, outbuf).
But outbuf will only contain the first line, that is
'item1 item2 item3'. How can I access the other lines?
Many thanks for your help!

RE: Help on UTL_FILE package

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

RE: Help on UTL_FILE package

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!).

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close