Update on Virtual Table from Oracle remote source fails

[former_member208449]

Hi SAP Community/ben.hofmans,

I have an SDA connection from Oracle to HANA.

Adapter - Oracle (Generic ODBC) 12c

I have enabled the DML mode to readwrite on the remote source. According to my understanding from SAP documentation, readwrite mode enables DML operations on Virtual Tables.

I added tables from remote source as virtual tables. I am able to do INSERT on the virtual tables, but UPDATE request fails with below error -

SAP DBTech JDBC: [7]: feature not supported: 'SET' clause can not be fully delegated to the remote source

Kindly suggest. Also please provide any documentation/source that might suggest the limitations with UPDATE on Virtual tables for oracle remote source.

Below updates fail -

UPDATE "SCHEMA"."VIRTUAL_TABLE"

SET LOAD_TIME = now()

WHERE NAME = 'TEST';

UPDATE"SCHEMA"."VIRTUAL_TABLE"

SET LOAD_TIME= CURRENT_TIMESTAMP

WHERE NAME = 'TEST';

However, this works -

UPDATE"SCHEMA"."VIRTUAL_TABLE"

SET LOAD_TIME = '2018-12-09 12:12:12'

WHERE NAME = 'TEST';

[mike_howles4]

I have the same issue as you. Trying to update a virtual table with a JOIN condition in my scenario, though. One half of the JOIN is a HANA temp table. I'm also wondering what a better workaround would be.