Home Forums SQL Server 2008 Working with Oracle "ORA-00936: missing expression" w/64bit R2 & OraOLEDB.Oracle provider RE: "ORA-00936: missing expression" w/64bit R2 & OraOLEDB.Oracle provider
Randy Knight
SSC-Addicted
Points: 468
More actions
January 27, 2011 at 1:31 am
#1278942
Try wrapping your Oracle statement in BEGIN END. This will pass it off to the PL/SQL parser. I have had success doing this with a variety of strange issues like this.