UTL_FILE pkg related issue

From: Vikas Kawatra <VKawatra_at_innoventry.com>
Date: Mon, 04 Jun 2001 11:44:28 -0700
Message-ID: <F001.0031AAC6.20010604113137@fatcity.com>

I use the UTL_FILE pkg to read a bin file and load the data into our database tables (insert or update) . The program works fine - but since we do updates too- we would like to protect out table - by checking the no of rows in the input file - The file has a Header and Tail - CAn someone suggest - how I can scan the binary file - and count the no of rows - before - processing the file ?

thanks

vikas
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Vikas Kawatra
  INET: VKawatra_at_innoventry.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Mon Jun 04 2001 - 13:44:28 CDT