Re: UTL.FILE

Alamelu wrote:
> I read the file now where do I put it I dont want to write it now. I

If you don't want to write, what would you like to do with it, then? My advice: write it into a table - could be a global temporary table.

> need to read all the records for the patients and check if there is any
> missing ionfo and there is no missing info then write it to one file

How would you know something is missing?

> otherwise write it to another file. Something like cursor. Maybe your
> answere is in what you wrote and Iprobably did not understand but

cursors work on tables/memory structures. Once you have the data within oracle (which version, by the way?!?), things are easy.

-- 
Regards,
Frank van Bortel