Re: UTL.FILE

From: Geoff Muldoon <gmuldoon_at_nospam.scu.edu.au>
Date: Wed, 18 May 2005 08:29:54 +1000
Message-ID: <MPG.1cf51b6c813465559896b6@news.x-privat.org>

In article <1116347319.645118.172180_at_o13g2000cwo.googlegroups.com>, crangaa1_at_ccf.org says...
> Thank you very much. I think my best bet is to write in a temporary
> table (which I had wanted to avoid) but I have to validate the data.
>
> Missing means, I need to get baseline and follow up infor for the
> patients and I am receiving IVUS data so each ohis events will have
> multiple records and hence I need to see that whast I receive for
> baselinf I need for follow up . Another check sometimes they send
> duplicate records by mistake. Ineed to catch that,.
>
> Thanks I think you are right I need a temp table.

Or maybe external tables, coupled with a stored procedure for your validation routine.

GM Received on Tue May 17 2005 - 17:29:54 CDT