Skip to Content

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

Sub selects in UPDATE_INSERT - JDBC Receiver - Oracle DB

Hi.

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.

Example:

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

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

<stmt>

<Data action="UPDATE_INSERT">

<table>DATA</table>

<access>

<DATA>13</DATA>

<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>

</access>

</Data>

</stmt>

</ns0:some_MT>

Regards...

Peter

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