Reading Flat Files from Oracle PL/SQL
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,
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
Search the Ask Tom website for UTL_FILE. There are some great examples on there.
I'm stmontgo and I approve of this message
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.
Click Here to Expand Forum to Full Width