Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 Transact-SQL (2012)
 Linked server

Author  Topic 

sravanim
Yak Posting Veteran

58 Posts

Posted - 2014-02-18 : 07:02:07
when i am trying to fetch data from linked server i got the below message

Error message:OLE DB provider "OraOLEDB.Oracle" for linked server "Linkedservername" returned message "ORA-00936: missing expression".

Query what i ran:select * from OPENQUERY([Linkedservername],'SELECT FROM Schemaname..Viewname');

TG
Master Smack Fu Yak Hacker

6065 Posts

Posted - 2014-02-18 : 16:38:01
Looks like you need help for Oracle and this site is specific to MS Sql Server.
However, your select statement looks to be missing a column list.
quote:
SELECT <need something here> FROM Schemaname..Viewname



Be One with the Optimizer
TG
Go to Top of Page
   

- Advertisement -