message error ORA-00936 when using JDBC adapter

[Former Member]

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

[former_member633453]

How did you resolve the problem?

[bhavesh_kantilal]

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

[Former Member]

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.