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

  • Found the problem! Single line comments ( -- my comment) in the SQL work fine for parsing and previewing, but evidently the 64bit provider strips out CRLF's which makes for bad SQL. Multi-line comments ( /* my comment */ ) are fine.