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

Question

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"

You are missing the '' in front of DD-MMM. But here might be more problems though. — Jens Krogsboell
– Jens Krogsboell, Commented Sep 12, 2014 at 10:21

Jens Krogsboell · Accepted Answer · 2014-09-12 10:32:27Z

1

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

answered Sep 12, 2014 at 10:23

Jens Krogsboell

1,12311 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

OLE DB provider "MSDAORA" for linked server "CBSLINKED" returned message "ORA-01821: date format not recognized ".