Home » SQL & PL/SQL » SQL & PL/SQL » UTL_FILE.GET_LINE (Oracle 9i)
UTL_FILE.GET_LINE [message #397946] Tue, 14 April 2009 12:09 Go to next message
Messages: 98
Registered: July 2007
Location: pune
Hi All,
Am using UTL_FILE.GET_LINE(v_file_type,v_rec);I have used v_rec as varchar2(4000);when am reading the file am not getting up to end of the line.Its reading in unformat mode.How to read the file up to end of the file.

Re: UTL_FILE.GET_LINE [message #397949 is a reply to message #397946] Tue, 14 April 2009 12:15 Go to previous messageGo to next message
Messages: 25520
Registered: January 2009
Location: SoCal
Senior Member
You need to help us by following the Posting Guidelines as stated below.
Please, please, please Read & Follow Posting Guidelines above.
Go to the section labeled "Practice" & do as directed.
Re: UTL_FILE.GET_LINE [message #397953 is a reply to message #397946] Tue, 14 April 2009 12:26 Go to previous messageGo to next message
Michel Cadot
Messages: 65079
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
How could we know what you did, what you have, what you want... ?
The only answer we can give you is: correct your code to fit your requirements.

Re: UTL_FILE.GET_LINE [message #397963 is a reply to message #397953] Tue, 14 April 2009 12:43 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member

UTL_FILE.get_line(l_file, l_text, 32767);

  ** GET_LINE - Get (read) a line of text from the file
  ** IN
  **   file - File handle (open in read mode)
  **   len  - input buffer length, default is null, max is 32767
  ** OUT
  **   buffer - next line of text in file
  **   no_data_found      - reached the end of file
  **   value_error        - line to long to store in buffer
  **   invalid_filehandle - not a valid file handle
  **   invalid_operation  - file is not open for reading
  **                      - file is open for byte mode access
  **   read_error         - OS error occurred during read
  **   charsetmismatch    - if the file is open for nchar data.
  PROCEDURE get_line(file   IN file_type,
                     buffer OUT VARCHAR2,
                     len    IN BINARY_INTEGER DEFAULT NULL);

Previous Topic: Parse of PL/SQL package Spec
Next Topic: Sequences or ROWID'S
Goto Forum:

Current Time: Thu Jul 20 13:50:24 CDT 2017

Total time taken to generate the page: 0.13424 seconds