I have a datafile spooled from MySql with columns seperated by '|'. Few tables have LOB columns. Could anyone help me how to write the sql*loader control file to handle CLOBS (not LOB files) ?

Thanks in advance!