Forum Stats

  • 3,770,265 Users
  • 2,253,087 Discussions
  • 7,875,378 Comments

Discussions

MERGE INTO not working in OLEDB

I've had several instances of MERGE INTO statements with a complex select query working just fine in SQL Developer (which I assume is using JDBC) but failing when I try to run them in SSIS using Oracle provider for OLE DB. The error I get is ORA-00936. Is this some known limitation with Oracle OLE DB driver and if so, where can I find the docs for that? I've been able to work around this issue by creating a view for the query inside the MERGE INTO but it's a hassle that I could do without. Unfortunately I can't post the sample query because I work in a highly secure environment, but the query contains a couple of joins and several subqueries in the where clause (not exists).

This discussion has been closed.