Why does this error occur when I try to run my script? Here is the script error:
INSERT INTO INTERACTIONS_12721561 * ERROR at line 22: ORA-06550: line 22, column 13: PL/SQL: ORA-00913: too many values ORA-06550: line 22, column 1: PL/SQL: SQL Statement ignored
The error "ORA-00913: too many values" means that the source table has more fields than the destination table. In this case, table INTERACTIONS_12721561 was a temp table created before the sync was install, and was missing the BBECSYNC field (found in the INTERACTIONS table). So when records from INTERACTIONS were trying to copy to INTERACTIONS_12721561, Oracle found it had no place to put the data from the missing field.
To fix this issue, compare the columns/fields of the 2 tables and add the missing one(s). Here is an example of updating a table with a new field:
ALTER TABLE INTERACTIONS_12721561 ADD BBECSYNC VARCHAR2(1);