Database Administration (MOSC)

MOSC Banner

OLE DB provider for linked server “ORADEV-LINK” supplied inconsistent metadata.

edited Oct 28, 2024 3:14PM in Database Administration (MOSC) 4 commentsQuestion

Hello.
I would like guidance regarding a problem that has arisen concerning the communication between a Windows MsSQL Server 2018 , hosting our CRM system
and a test database 19C on Oracle Linux 8 Server, hosting the ERP software.

We have created a Linked_server connection between the two databases, and while attempting to update an Oracle table, we receive the following message:

" Msg 7353, Level 16, State 1, Procedure COD.Interface_Upload, Line 29 [Batch Start Line 20] The OLE DB provider “OraOLEDB.Oracle” for linked server “ORADEV-LINK” supplied inconsistent metadata. An extra column was supplied during execution that was not found at compile time. "

Based on the investigation by the development team which is handling the project, the installation of Oracle

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center