UTL_FILE and UTL_FILE.FILE_TYPE

From: Ian Downham <ian.downham_at_which.net>
Date: Mon, 19 Jul 1999 22:28:30 +0100
Message-ID: <3793987D.939408BA@which.net>

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

--
Click here to e-mail me mailto:ian.downham_at_which.net or remove extra m in downham Received on Mon Jul 19 1999 - 16:28:30 CDT