Intermediate
24-13. | Which of the following actions are not possible with UTL_FILE?
|
24-14. | What is displayed in your SQL*Plus session when the following program is run (assume that UTL_FILE has the necessary privileges to read the file)? DECLARE
fid UTL_FILE.FILE_TYPE :=
UTL_FILE.FOPEN ('/tmp', 'twolines.txt', 'R');
line VARCHAR2(2000);
BEGIN
LOOP
UTL_FILE.GET_LINE (fid, line);
DBMS_OUTPUT.PUT_LINE (line);
END LOOP;
END;Here are the contents of the data file that is read: I am not a very large file, really I consist of nothing more than two lines. |
24-15. | Write a procedure to display the contents of the specified file to standard output (usually your screen). Make sure you don’t leave a file open if an error occurs. |
24-16. | What is wrong with the following code? CREATE TYPE string_list_t IS TABLE OF VARCHAR2(255); / 1 CREATE OR REPLACE PROGRAM nest2file (file IN VARCHAR2, 2 list IN string_list_t%TYPE) 3 /* Move contents of nested table to file. */ 4 IS 5 fid UTL_FILE.FILE_TYPE := UTL_FILE.FOPEN (file, 'R'); 6 line VARCHAR2(100); 7 linenum INTEGER; 8 BEGIN 9 FOR linenum IN list.LAST .. list.FIRST 10 LOOP 11 line := list(linenum); 12 UTL_FILE.WRITE_LINE (line); ... |