Advanced Oracle PL/SQL Programming with Packages

Advanced Oracle PL/SQL Programming with PackagesSearch this book
Previous: 13.7 Copying File ContentsChapter 13
PLVfile: Reading and Writing Operating System Files
Next: 13.9 Handling File Errors with PLVfile
 

13.8 Displaying File Contents

Use the display procedures (overloaded for file name and file handle) to display the contents of an operating system file from within a PL/SQL program. The headers for these procedures are:

PROCEDURE display 
   (file_in IN UTL_FILE.FILE_TYPE, 
    header_in IN VARCHAR2 := NULL,
    start_in IN INTEGER := 1,
    end_in IN INTEGER := NULL);

PROCEDURE display
   (file_in IN VARCHAR2, 
    header_in IN VARCHAR2 := NULL,
    start_in IN INTEGER := 1,
    end_in IN INTEGER := NULL);

where file_in is the file name or the handle, header_in is an optional header for the display, and the start_in and end_in arguments specify the rows which you wish to display. If the end_in argument is NULL (the default value), then all lines from the starting line number to the end of the file will be displayed.


Previous: 13.7 Copying File ContentsAdvanced Oracle PL/SQL Programming with PackagesNext: 13.9 Handling File Errors with PLVfile
13.7 Copying File ContentsBook Index13.9 Handling File Errors with PLVfile

The Oracle Library Navigation

Copyright (c) 2000 O'Reilly & Associates. All rights reserved.

Library Home Oracle PL/SQL Programming, 2nd. Ed. Guide to Oracle 8i Features Oracle Built-in Packages Advanced PL/SQL Programming with Packages Oracle Web Applications Oracle PL/SQL Language Pocket Reference Oracle PL/SQL Built-ins Pocket Reference