Question
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,
^ _ ^
AdChoices