Very Computer

1. UTL_FILE and UTL_FILE.FILE_TYPE

Hi,
   Does anyone know of a way to store the filehandle returned value from
UTL_FILE.FOPEN in a PL/SQL table ?

eg.

          type file_details is record
               (disp_pipe_id varchar2(20),
                disp_file_id utl_file.file_type);   <<<<=============
doesn't seem to like this bit ?!?!

          type tab_file_details is table of file_details
               index by binary_integer;

          rec_file_detail    tab_file_details;

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

   if rec_file_detail(rec_counter).disp_pipe_id = returnpipe then
        file_id := rec_file_detail(rec_counter).disp_file_id;
        file_open := utl_file.is_open(file_id);
        if file_open then
            anyerrors := 'File already open';
            exit ;
        end if;
    end if;

Sorry if it's a stupid question

Thanks in advance if it's not

Ian

--

or remove extra m in downham

2. DB online Synchronization?

3. UTL_FILE how to use utl_file.get_line

4. SQL Server cant manage a 30gig Database ?

5. UTL_FILE : Is it possible to use utl_file through network path ?

6. if( ExecuteTemplateFile == E_FAIL ) Yell("HELP!");

7. Q: Solution for bug 458336? (UTL_FILE.PUT() -> UTL_FILE.WRITE_ERROR)

8. DBCC PAGE command in SQL7

9. UTL_FILE-Equivalency

10. Help using UTL_FILE in Oracle stored procs

11. Synchronize File Acces via PL/SQL UTL_FILE Package

12. Re : UTL_FILE

13. Using UTL_FILE