Oracle 11g: Issue with INSERT ALL

Hello, all,

I'm trying to migrate data from an old schema to a new schema via ColdFusion, and I'm getting an error message.

<cfquery name="old_data" datasource="#application.dsn_old#">
SELECT colA, colB, colC
FROM old_table
</cfquery>
<cfquery name="new_data" datasource="#application.dsn_new#">
INSERT ALL
     <cfoutput query="old_data">
          into new_table(aCol, bCol, cCol)
               values(colA, colB, colC)
     </cfoutput>
SELECT * from dual;
</cfquery>

904: ORA-00904: "colC": Invalid identifier

If I CFDUMP the first query, all the data is there.  Why does Oracle think that colC is invalid?

V/r,

^ _ ^