Re: UTL_FILE and UTL_FILE.FILE_TYPE

The file handle is actually a record, so it can not be stored in another record. One way around this is to create a separate table that is kept in sync with your original table.

Hope this helps,
Patrick Flahan

Ian Downham <ian.downham_at_which.net> wrote in message news:3793987D.939408BA_at_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 - 19:46:36 CDT