Skip to Content

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

Sub selects in UPDATE_INSERT - JDBC Receiver - Oracle DB


Short question...

Anybody know if subselects are permitted in the JDBC Receiver adapters UPDATE_INSERT statement.

I tried with and without the hasQuot attribe without luck.

Error message is: ORA-00936 - missing expression.


<?xml version="1.0" encoding="UTF-8"?>

<ns0:some_MT xmlns:ns0="http://test">


<Data action="UPDATE_INSERT">




<UTC_TIME hasQuot="No">to_date('2008-10-02 04:00:00', 'YYYY-MM-DD HH24:MI:SS')</UTC_TIME>

<DATA_ID hasQuot="No">select data_id from data_id_table where id = 34</DATA_ID>







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