Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2006
    Posts
    46

    Unanswered: SQL LOADER and newlines

    I am trying to load a CSV file into Oracle by using SQL Loader.
    The CSV file has something in it called OCR (optical character recognition) and I using a CLOB to store this in. The problem is that I am only getting a small part of my OCR text into the CLOB and I think it is because the CSV has a lot of ASC(174's in it -- i.e. ) which could be part of the original document. This character, I think, trips up SQL Loader. Is there a way of getting around this.

    Thanks.

  2. #2
    Join Date
    Jul 2003
    Posts
    2,296
    use a different delimeter.
    or - use the "optionally enclosed by [x]" option and enclose that section in
    a different format (ie: square brackets, carats, pipes, whatever
    - The_Duck
    you can lead someone to something but they will never learn anything ...

Posting Permissions

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