Skip to Content
0

Update on Virtual Table from Oracle remote source fails

May 06 at 12:00 PM

66

avatar image
G B

Hi SAP Community/Former Member,

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers