Skip to Content
avatar image
Former Member

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

5 Answers

  • avatar image
    Former Member
    Sep 24, 2008 at 03:57 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 24, 2008 at 04:32 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 24, 2008 at 04:54 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 24, 2008 at 05:58 AM

    Hi Naveen,

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

    Regards,

    Skumar

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 24, 2008 at 06:11 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded