DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Reading Flat Files from Oracle PL/SQL

  1. #1
    Join Date
    Oct 2004
    Posts
    18

    Reading Flat Files from Oracle PL/SQL

    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

  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Package UTL_FILE.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  3. #3
    Join Date
    Jul 2002
    Location
    Northampton, England
    Posts
    612
    Search the Ask Tom website for UTL_FILE. There are some great examples on there.

  4. #4
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    Why not external tables?
    I'm stmontgo and I approve of this message

  5. #5
    Join Date
    Dec 2000
    Posts
    126
    use external table if you have 9i

  6. #6
    Join Date
    Mar 2001
    Location
    Reading, U.K
    Posts
    598
    What factors will determine which approach to take for uploading a text file, i.e.,
    - UTL_FILE package or
    - External table/SQL Loader
    Cheers!
    OraKid.

  7. #7
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width