OLE DB provider "OraOLEDB.Oracle" for linked server "PRISM" returned message Msg 7340, Level 16, State 2, Line 4 Cannot create a column accessor for OLE DB provider "OraOLEDB.Oracle" for linked server "PRISM"

kristusha
Kilo Explorer

‎10-06-2017 07:29 AM

I'm running the sql query using function in the select statement - it is running fine, returning an output from the Oracle DB, but from 64 bit SQL Server returns an error on the function part. If the function is commented also returns an output, but need to use the function. Using connection link from SQL Server to Orcale DB. Worked fine before the upgrade to the next version. Th only changes were in the oracle parameters that max the length.

OLE DB provider "OraOLEDB.Oracle" for linked server "PRISM" returned message "The system cannot find message text for message number 0x80040e21 in the message file for OraOLEDB.".

Msg 7340, Level 16, State 2, Line 4

Cannot create a column accessor for OLE DB provider "OraOLEDB.Oracle" for linked server "PRISM".

Please help to resolve this issue.

0 Helpfuls
  • 7,163 Views
1 REPLY 1