Results 1 to 9 of 9
  1. #1
    Join Date
    Jun 2003
    Posts
    5

    Exclamation Unanswered: plzzzzzzzzzzzzzzz help urgent

    How to with PL/SQL code import data into an Oracle table from (a 'TAB ' delimited) text file ???? and i wanna to use oracle forms with pl/sql not to use sqlldr
    Last edited by mmahdy; 09-23-04 at 15:38.

  2. #2
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    If you are using Forms 9i or above, you can use external tables. Otherwise, use text_io and parse. WHy don't you want to use sqlldr, that is what it is for. You can also run sqlldr from inside a form by using a host command.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  3. #3
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >If you are using Forms 9i or above, you can use external tables
    HUH?
    What does Form9i have to do with external tables?
    I have Forms 9i accessing a V7.3.4.5 DB which does not support external tables.
    Forms 9i are web forms; which even work on a PDA; which does not support external tables either.
    >You can also run sqlldr from inside a form by using a host command.
    NOT if it is a 9i Web Form, you can't.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  4. #4
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    Quote Originally Posted by anacedent
    >If you are using Forms 9i or above, you can use external tables
    HUH?
    What does Form9i have to do with external tables?
    I have Forms 9i accessing a V7.3.4.5 DB which does not support external tables.
    Forms 9i are web forms; which even work on a PDA; which does not support external tables either.
    >You can also run sqlldr from inside a form by using a host command.
    NOT if it is a 9i Web Form, you can't.
    Sorry, I was assuming that the sql engine in forms in 9i would have caught up to the database sql engine. I haven't had a chance to use 9i forms yet. Oh well, hoisted on my own petard.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  5. #5
    Join Date
    May 2004
    Location
    Dominican Republic
    Posts
    721
    However, your comment about using "text_io and parse" is valid, beilstwh. You can get to read the file from forms using text_io package and its procedures/functions.

  6. #6
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  7. #7
    Join Date
    Jun 2003
    Posts
    5

    Exclamation thnx all

    thnx all about this valuable support but i'm already use text_io package in posting data from text file but the formatting of this data is fixed width
    not (tabed delimited) now i want to use any package to resolve this tab delimited data ???? plz help and more clear

  8. #8
    Join Date
    Jul 2003
    Posts
    2,296
    convert/replace the TABS with something else if that is what you are
    having problems with.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  9. #9
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    use text_io to read in a line, parse it into fields using instr, use the fields, and get the next record;
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

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