CODEWITHSUNDEEP
sql-serveroracle-databasesql-server-2008-r2oracle10gopenquery
Dgan
Dgan

Reputation: 10285

Error while Executing OPENQUERY with Oracle 10g in SQL Server 2008 R2

execute ('call CBSIVRDB.FIU_INSERT ('' TO_DATE(''01-JUN-2014'',DD-MMM-YYYY) '',''TO_DATE(''30-JUN-2014'',DD-MMM-YYYY)'') ') at CBSLINKED

Error:

OLE DB provider "MSDAORA" for linked server "CBSLINKED" returned message "ORA-00907: missing right parenthesis"

Upvotes: 0

Views: 582

Answers (1)

Jens Krogsboell
Jens Krogsboell

Reputation: 1123

Try this:

CBSIVRDB.FIU_INSERT (TO_DATE(''01-JUN-2014'',''DD-MON-YYYY''),TO_DATE(''30-JUN-2014'',''DD-MON-YYYY''))

or more precisely

execute ('call CBSIVRDB.FIU_INSERT (TO_DATE(''01-JUN-2014'',''DD-MON-YYYY''),TO_DATE(''30-JUN-2014'',''DD-MON-YYYY''))') at CBSLINKED

Upvotes: 1

Related Questions