Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

Former Member
Not what you were looking for? View more on this topic or Ask a question