0
  • Linked Server Name:CBSLINKED //Oracle 10g
  • Name of Database if oracle : CBSIVRDB
  • Name of Stored Procedure : FIU_INSERT
  • having parameter as (FromDate,ToDate)
  • My DB: SQL server 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"

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Dgan
  • 10,077
  • 1
  • 29
  • 51

1 Answers1

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
Jens Krogsboell
  • 1,093
  • 11
  • 18
  • OLE DB provider "MSDAORA" for linked server "CBSLINKED" returned message "ORA-01821: date format not recognized ". – Dgan Sep 12 '14 at 10:28