JDBC receiver error - ORA-00913: too many values

[Former Member]

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

[Former Member]

HI Naveen,

Just check whether you are inserting any numeric value with comma(,),for example if u want enter MRP as 12,500 u have to insert 12500(not 12,500).

check all values like that.

Regards,

Sreedhar Goud.

[Former Member]

Hi Naveen,

Basically this is the Basis issue, contact to basis guys, they will find out the error easily.

Regards,

Skumar

[Former Member]

Hi

I think this is due to in-correct SQL syntax

Check the OSS note

Note 723149 - Error due to incorrect SQL syntax

Regards

MD

[former_member183906]

1. First check all FIELDS have been given values as per their table description.

2. No extra field is thr ,whr value u have assigned.

[Former Member]

Hi

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

.

Well the error you mention generally occurs when the insert statement has more fields mention than in the table .ie you are mentioning extra field .aur this error is due to the field lenght of any of the filed you had to check in the oracle itself by using the command DESCRIBE there you ll be able to see the field lenght of each and every field .

hope your problem got resolved :

Regard's

Chetan Ahuja