Using SQL* Loader to load inline CLOBs, getting error

Hi, I am attempting to load a file using SQL*Loader to store html pages as CLOBs in an Oracle 8.1.7 db.

Previously we stored the html pages as LONGs, but since we are moving to a new database we thought we needed to change the LONGs to CLOBs. However, the existing control file will not work. Here is the relevant section of the existing control file:

into table cra_stg_invoice_cb_page                                 
when (1:1) = 'I'                                                   
 (invoice_number                POSITION(02:11) CHAR(10),          
  company_code                  POSITION(12:15) CHAR(4),           
  fiscal_year                   POSITION(16:19) CHAR,              
  customer_number               POSITION(20:29) CHAR(10),          
  page_number                   POSITION(30:32) DECIMAL EXTERNAL,  
  html_page                     POSITION(33)    VARCHAR(20000)  

When I try to change the datatype of the last column ("html_page") to CHAR instead of VARCHAR(20000) (as it suggests in the Oracle reference manual), I get this error message:

SQL*Loader-462: error inserting LOB into column HTML_PAGE, row 2, table cra_stg_invoice_cb_page ORA-24806: LOB form mismatch

I've tried giving the CHAR a size (like 20000), or making the POSITION go from (33:19999), but nothing seems to work. Any insight would be appreciated.

Thanks,
Travis Bryant
tbryant_at_chevrontexaco.com Received on Mon Feb 17 2003 - 19:33:34 CST