Skip to Content
avatar image
Former Member

Inserting fields into an Oracle DB ERROR

Hi everyone

I have to insert info into an Oracle Database from R3.

The functional consultant is sending the info but when I see the sxmb_moni I see that XI did not deliver the message, the error that is shown there is:

com.sap.aii.af.ra.ms.api.DeliveryException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'tablename' (structure 'STATEMENTNAME'): java.sql.SQLException: ORA-00936: missing expression.

I have already checked the Message Mapping and Iu2019m sure that the fields that Iu2019m trying to insert are correct.

Can someone help me or tell me what to try??

Thanks in advanced

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

8 Answers

  • Best Answer
    Oct 16, 2008 at 01:59 AM

    You must be specifying the SQL XML strucuture wrongly in the mapping. Verify with the documentation. There are lot of threads explaing the same. Search.

    VJ

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 16, 2008 at 10:20 AM

    Hi,

    i have faced this problem many a times

    Error lies in table/stored proc. 'tablename' (structure 'STATEMENTNAME')

    GO to IR and search STATEMENTNAME object.

    There lookinot tag 'tablename' there must be some specific defination of max lenght etc.error that can not be parsed.

    Check and loet me know that field value.

    Regards,

    Sumit Gupta

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Gaurav

      Finally I could insert fileds into the Oracle DB but I had to deactivate some fileds because the info that XI was trying to insert into the DB were negative numbers, and Oracle was rejecting those numbers, that´s why I deactivate those fields.

      It seems like Sap send negative numbers with the minus sign ➖ at the right side and Oracle Number Type is expecting to receive this sign at the left sign.

      Do someone know if there is a way in XI to pass the negative sign of SAP from right to the left side like Oracle is expecting it ?

      Or how can i solve this problem??

      Thanks.

      Emmanuel

  • Oct 16, 2008 at 03:32 AM
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 16, 2008 at 02:56 AM

    Hi

    Check with the table name you are passing to field.

    Check for the document formats and correct it

    http://help.sap.com/saphelp_nw70/helpdata/EN/2e/96fd3f2d14e869e10000000a155106/content.htm

    Thanks

    Gaurav

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 16, 2008 at 04:40 AM

    Hi Emmanuel,

    Try to test the Message Mapping.If it successful.try to check with Basis guys.

    Regards,

    Sateesh

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 16, 2008 at 06:11 AM

    take your payload which you are passing to oracle from xi and try to execute the same in oracle editor, take help of your DBA . there must be som mapping issue which leads to errornous sql structure.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 16, 2008 at 07:37 AM

    Hi

    -> Can you check with the table name of your structure 'STATEMENTNAME'

    ->ORA-00936: missing expression:

    Check whether the values are already present in the database for the particular fields,so you may have to use UPDATE_INSERT.

    ->Check if there is any missing syntax.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 16, 2008 at 07:46 AM

    Hi,

    Once again check the the target structure as mentioned in this blog.

    FILE to JDBC Adapter using SAP XI 3.0

    Also make sure the table name is correct coz it is case sensitive.

    Regards,

    Sarvesh

    Add comment
    10|10000 characters needed characters exceeded