Linked Server from SQL Server 2005 to Oracle Issue

Hi all,


I have a Linked Server object in SQL Server 2005 to query an Oracle view. The view returns all table rows.

Linked server name in sql server 2005 is : ASE

Linked Server object in SQL Server 2005 is connecting to Oracle view successfully.


select * FROM OPENQUERY(ASE,'SELECT TOP 1 EMPCODEEIN FROM ASE_VIEW_00050')


My problem while execute the above select query, I am getting below error:

OLE DB provider "OraOLEDB.Oracle" for linked server "ASE" returned message "ORA-00923: FROM keyword not found where expected".
Msg 7321, Level 16, State 2, Line 1
An error occurred while preparing the query "SELECT TOP 1 EMPCODEEIN FROM ASE_VIEW_00050" for execution against OLE DB provider "OraOLEDB.Oracle" for linked server "ASE".


Can any one help me out to resolve the issue?

Thanks in advance.

Thanks
Ping

Can you query base table on Oracle via linked server?