Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

JDBC receiver error - ORA-00913: too many values

Hi all,

Facing a strange issue with proxy-jdbc issue.

Message fails with error - ORA-00913: too many values

Handling the missing fields from the source with - Empty String in the comm. Channel

Empty string handling works fine - whenever there is no value coming form souce, null is inserted into the field value on the DB.

Trying to insert the same data manually, it works fine. But gives this error END2END.

When testing END2END, if the field values are made couple of chars less in length, that works fine....fails with the actual data.....seems to be the issue with the field lenghts on the DB.

Increased all the lengths by 10 chars..still does not work.

Except the key fields of the DB table, all others are nullable.

Is there anything else, I am missing...

Note: Generally, ORA-00913: too many values comes when the number of fields and the number of values donot match in an INSERT/UPDATE statement.

reg

Not what you were looking for? View more on this topic or Ask a question