December 7, 2020 at 3:57 am
Hi,,
Connected SQL server with Oracle 19 DB via Linked Servers;
SQL Serer table has 4 columns and Oracle has same 4 columns and 1 Autogenerated column.
Description :
The view first deletes the existing data inside the table, and then the view inserts data into the same tables. All of these views will run once correctly, but then will fail when ran a second time when the view is trying to insert the data into the table. The second time the view tries to insert data, the view is including a ROWID column in the dataset, which changes the schema the source table is expecting, which causes the failure. It seems like when this code is ran more than once in the same transaction it creates the issue.
It was working fine in Oracle older version and creates the issue in Oracle 19.
Error :
The OLE DB provider "OraOLEDB.Oracle" for linked server "TDG_ORACLE" supplied inconsistent metadata. An extra column was supplied during execution that was not found at compile time.
Analysis so for :
Used the OPTION (RECOMPILE) option and keep on progress for long time to execute and no result.
Checked the Column order positions in SysColumns table and looks fine
Please advise.
December 8, 2020 at 4:10 am
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
January 4, 2021 at 4:05 pm
Hi,
I have same problem. Any solution?
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply