ORA-00932: inconsistent datatypes: expected - got LONG
This post is dedicated to one of the most elusive errors I've encountered. I haven't been able to replicate the issue from my notes at the time, so this summary is from memory. Hopefully this will help anyone else (or future me) that comes across this one. The scenario: Query a readonly 9i db from 11g via dblink. Queries kept erroring with ORA-00932. None of the columns I was looking at were long. All columns involved were either number, varchar2, or date.