SQL*Loader loading multiple-line fields?

Dear Oracle people,

        I ran into a problem with SQL*Loader to load a char field that contains multiple lines. The continuation character just merge multiple physical records into a logical record but doesn't help with a record that has a multi-line field.

        For example, there is a varchar field called address, and normally it will have three lines, the street, the city, and the country. I was able to enter this data from the GUI that we had and extracted it into a text file for some processing. But when I try to load it back to the database by using SQL*Loader, the newline in the filed becomes a problem and SQL*Loader thinks that they are three records instead of one with multiple lines.

        Does anyone have experience with the same problem that I have?

Your help will be much appreciated.

Thanks
Frank_at_clarify.com
408-428-0248 Received on Tue Aug 09 1994 - 23:50:36 CEST