Gentlemen and Ladies: I am using Oracle's sqlldr utility to load a flat file into a staging table for further processing. I have a question that I cannot get answered from The Google... How do I select a character string longer than 4000? Can I concatenate somehow using boundfillers? Do I need to use a special type (not CHAR)? <tip type="sqlldr"> If you are specifying a ROWS parameter and it seems to be ignored based on the commit interval that results, try increasing the BINDSIZE to 4054*ROWS (e.g. for ROWS=500, try BINDSIZE=2027000). http://lbdwww.epfl.ch/f/teaching/courses/oracle9i/server.920/a96652/ch04.htm#1004690 </tip> -- Matt Warden Cincinnati, OH, USA http://mattwarden.com This email proudly and graciously contributes to entropy.