Re: Problems importing with SQL Loader

Paul,

>at least one of the fields in each rejected row has an "&#" in it.
>
>Why do these characters cause the import to fail? Can anything be done about
>it?

Strange... rejected files have nothing to do with bad data. It depends on the WHEN clause.. Take a look at that...

If you're working on UNIX, you might want to change the data using some tool. In HP-UX you could try the tool "tr".

• Martin Jesterhoudt
• Martin.Jesterhoudt(replace this by @)usa.net

  ---