Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2010
    Posts
    2

    Post Unanswered: Import data from custom file

    Hi all,

    I've a situation where in am to load the data from a custom file into a table using oracle 9i(not supposed to use later versions). the file format is given below.

    @col1 = col1_value,@col2 = col2_value,@col3 = col3_value,@col4 = col4_value
    @col1 = col1_value,@col2 = col2_value,@col3 = col3_value,@col4 = col4_value
    @col1 = col1_value,@col2 = col2_value,@col3 = col3_value,@col4 = col4_value
    @col1 = col1_value,@col2 = col2_value,@col3 = col3_value,@col4 = col4_value

    The data after loading and validating using a custom procedure, needs to be exported to a xml file.
    Please help me out.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Since you are going OS text file to OS text file, why get Oracle involved at all.
    This could be done using PERL with a simple custom converted code.
    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.

  3. #3
    Join Date
    Aug 2010
    Posts
    2
    thanks for the reply.
    but, i cannot use technologies other than oracle. And there are some custom procedures and objects that take data for business from the table loaded from the file.

Tags for this Thread

Posting Permissions

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