Skip to Content
avatar image
Former Member

message error ORA-00936 when using JDBC adapter

Hi all,

I'm using the folow scenario:

RFC --> XI --> JDBC

RFC <-- XI <-- JDBC (response)

It's a SYNCHRONOUS interface.

RFC call without COMMIT WORK:

CALL FUNCTION 'Y_TESTE_NEI'

DESTINATION 'RFC_XI'

EXPORTING

DATE_FROM = v_data_from

DATE_TO = v_data_to

TABLES

t_return = t_dados.

I'm not using KEY in JDBC message, because for test I want to get entiry table, and I set the communication channel JDBC to KEY not mandatory.

I'm not having mapping error, in SXMB_MONI I can see the two messages of interface, but both with SYSTEM ERROR.

In JDBC adapter in Runtime Workbench apears the follow message error:

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

And DUMP in function call in R/3: CALL_FUNCTION_REMOTE_ERROR

Could anyone help me about this problem ?

Thanks in advance.

Regis Ferrato

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Apr 07, 2006 at 02:57 AM

    Hi Regis,

    I did the same scenario just now. The error you get is, you need to check whether the fields you are entering into the database have correct datatypes.

    Check out your database structure with your structure in XI, and also test in Message Mapping, to make sure you are sending correct values.

    In my case I was sending date like this '10-12-06', but my DB accepts only '101206'. So I removed the '-'. It was fine .

    The Dumping error is not due to your ABAP, due to the DB operation.

    Let me know Whether I am correct.

    Raj.

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 07, 2006 at 03:06 AM

    Hi Regis,

    the strored procedure that your are trying to call from the JDBS adapter expects some input parameter and you are not passing that to it.

    While passing parameters to the Stored Procedure, make sure that the field name in your Datatype matches with the varibale used in the stored procedure.

    Regards,

    Bhavesh

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 03, 2008 at 12:25 AM

    How did you resolve the problem?

    Add comment
    10|10000 characters needed characters exceeded