Fordraiders
asked on
error on open query statement for linked server
problem getting open query to run
i keep getting an error when trying to run this openquery ?
INSERT INTO
[Metrics].[dbo].[EXTRACT_C USTOMERPRI CE_staging ]
([PROJECTID]
,[LINEITEMID]
,[CUSTOMERPRICE]
,[WWGSKUPRICE]
,[WWGSKU])
SELECT
[PROJECTID],
[LINEITEMID],
[CUSTOMERPRICE],
[PRICE],
[SKU]
FROM OPENQUERY (XREF_PROD, 'select
[PROJECTID],
[LINEITEMID],
[CUSTOMERPRICE],
[PRICE],
[SKU]
FROM xref.xref_results')
OLE DB provider "OraOLEDB.Oracle" for linked server "XREF_PROD" returned message "ORA-00936: missing expression".
Msg 7321, Level 16, State 2, Line 1
An error occurred while preparing the query "select
[PROJECTID],
[LINEITEMID],
[CUSTOMERPRICE],
[PRICE],
[SKU]
FROM xref.xref_results" for execution against OLE DB provider "OraOLEDB.Oracle" for linked server "XREF_PROD".
Thanks
fordraiders
i keep getting an error when trying to run this openquery ?
INSERT INTO
[Metrics].[dbo].[EXTRACT_C
([PROJECTID]
,[LINEITEMID]
,[CUSTOMERPRICE]
,[WWGSKUPRICE]
,[WWGSKU])
SELECT
[PROJECTID],
[LINEITEMID],
[CUSTOMERPRICE],
[PRICE],
[SKU]
FROM OPENQUERY (XREF_PROD, 'select
[PROJECTID],
[LINEITEMID],
[CUSTOMERPRICE],
[PRICE],
[SKU]
FROM xref.xref_results')
OLE DB provider "OraOLEDB.Oracle" for linked server "XREF_PROD" returned message "ORA-00936: missing expression".
Msg 7321, Level 16, State 2, Line 1
An error occurred while preparing the query "select
[PROJECTID],
[LINEITEMID],
[CUSTOMERPRICE],
[PRICE],
[SKU]
FROM xref.xref_results" for execution against OLE DB provider "OraOLEDB.Oracle" for linked server "XREF_PROD".
Thanks
fordraiders
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Heh... it's easy to miss since it actually does work a few lines up, in the outer query ;-)
ASKER