Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

UTF File Read

Posted on 1998-11-17
1
Medium Priority
?
336 Views
Last Modified: 2008-03-17
What is the equivalent of
         while(fgets(Buffer,80,fp));
in UTF_file operations?

How do I read until EOF?
0
Comment
Question by:lvenkat
1 Comment
 
LVL 4

Accepted Solution

by:
sganta earned 400 total points
ID: 1082620
Hi,


....
....
LOOP
BEGIN
  GET_LINE(file_handle,buffer);
  ...
EXCEPTION
  WHEN NO_DATA_FOUND THEN
    EXIT;
END;
END LOOP;
.......
.......


Where
GET_LINE(file_handle IN FILE_TYPE, buffer OUT VARCHAR2);

       Read a line of text from the file.

   Parameter:

       file_handle - File handle returned from the FOPEN function that you want to get a line of text from buffer - Data buffer to store the next line of text in the file.

   Exceptions raised:

       NO_DATA_FOUND   - reached the end of file
       VALUE_ERROR   - line too long to store in buffer
       INVALID_FILEHANDLE - not a valid file handle
       INVALID_OPERATION  - file is not open for reading
       READ_ERROR   - OS error occurred during read


Hope this helps you.


0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
Via a live example, show how to take different types of Oracle backups using RMAN.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

916 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question