Printable View
Hi,
Every 3 days I got Flat Files as a Source. What I have to do is, read that Flat File and insert into Database Tables. While inserting into that tables, may be update/Delete the Front end Application at the same time.
Could any one help me the best solution for this.
Thanks in Advance,
SankarG
Package UTL_FILE.
Search the Ask Tom website for UTL_FILE. There are some great examples on there.
Why not external tables?
use external table if you have 9i
What factors will determine which approach to take for uploading a text file, i.e.,
- UTL_FILE package or
- External table/SQL Loader
If you are not changing the source file, then use SQL Loader, this is very fast.
Or UTL_FILE or external table will help.
If you are using 9i, then try PIPELINE fn. The real advantage of PIPELINE is it does not wait to fetch all the rows. As soon as it reads some rows, it will pass on to the calling routine.
Tamil