I am having problem with pulling data from Linked Server that I have created using "Oracle Oledb Provider". I am able to created Linked server and tested the connection successfully. But I am unable select the data from table when running SELECT statement. I have used both four part naming and OPENQUERY method. I am getting same error in both cases.
Here is the error I am getting.
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "OraOLEDB.Oracle" for linked server "IMPRX_D" reported an error. The provider did not give any information about the error.
Msg 7330, Level 16, State 2, Line 1
Cannot fetch a row from OLE DB provider "OraOLEDB.Oracle" for linked server "IMPRX_D".
SQL Server 2005 SP3 32-Bit
Windows 2008 R2 64 Bit
Oracle 11g Client 64 bit
Please let me know if I missed to provide any details.