Paul,

Another question, What if I have the same table with 10 fields, but I have one field in the table that contains more than 4000 characters.

What would be my best alternative then? Could you point me in the right direction in defining this table with the clob/blob datatypes. Also, because I'm now using the clob/blob data types, how will I load the content to my oracle table?

Thanks again.