Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
MERGE INTO TARGET (...)
WHEN NOT MATCHED THEN INSERT (COL1,COL2,,,,,,,,,,,,,,,,,,,,,,,,,,,,)
VALUES (source.COL1,source.COL2,,,,,,,,,,,,,,,,,,,,,,,,,,,,)
Exception in component tELTOracleOutput_1 java.sql.SQLSyntaxErrorException: ORA-00947: nombre de valeurs insuffisant
if(!useMergeInsert)
useInsertWhere = false;
if (useMergeInsert) {
boolean isfirstInsertWhere = true;
String keyColumnName=null;
for(Map<String, String> keyColumn:insertColumns){
if (isfirstInsertWhere) {
isfirstInsertWhere = false;
}else {
mergeInsertName.append(",");
mergeInsertValue.append(",");
}
if (keyColumn.get("INSERT").equals("true")) {
keyColumnName=keyColumn.get("SCHEMA_COLUMN");
keyColumnName = new Column(metadata.getColumn(keyColumnName)).getName();
mergeInsertName.append(keyColumnName);
mergeInsertValue.append("source." + keyColumnName);
}
}
%>
mergeQuery += " WHEN NOT MATCHED THEN INSERT ( <%=mergeInsertName%>) VALUES ( <%=mergeInsertValue%>) ";
<%
}