Data Transfer between InterSystems Cache & Oracle.

[shaiknayeemuddin]

Hi,

I am facing one problem,

We have data in Oracle Table and fetching that data from Cache Database using link server concept.

I am able to fetch data through Cache query in Cache Studio from Oracle, like

Cache Query:
SELECT * FROM DATAMASK.TBL_MASKED_STG;

Here DATAMASK.TBL_MASKED_STG is link Table in cache (Table of Oracle).

But if I try to do Bulk update / Bulk Insert into Cache table using link table then I am getting error.

Cache Query:
INSERT INTO Sample.TestMaskClass (ACCOUNT_ID) SELECT ACCOUNT_ID FROM DATAMASK.TBL_MASKED_STG

Here Sample.TestMaskClass is Cache Table and DATAMASK.TBL_MASKED_STG is link Table in cache.

Error Message:
[Oracle][ODBC][Ora]ORA-00928: missing SELECT keyword.


Any help or comments or suggestion for this problem...?

Thanks in Advance & Waiting for kind reply.

Regards,
Nayeem