ORA-00913 too many values
Cause: The SQL statement requires
two sets of values equal in number.
This error occurs when the second
set contains more items than the
first set. For example, the subquery
in a WHERE or HAVING clause may
return too many columns, or a VALUES
or SELECT clause may return more
columns than are listed in the
Action: Check the number of items in
each set and change the SQL
statement to make them equal.
resolve case like these you should first
be sure to have
where DBMS_REPCAT_RGT was executed.
SQL> alter session set
For OEM, you may need to change the
language that has been set in
default in Windows locale using:
Start> Control Panel>Regional
important tat this behavior with
ORA-00913 is associated with bug
2227755, and has been fixed in some
Oracle Technology Forums, a user is
reminded that in order to avoid
ORA-00913, you have to keep in mind that
can update as many records as you want,
as many as your undo can support."