I'm not using any LOB's in the queries so why in the blue heck does Oracle want to their LOB locators? I did a search and thankfully found where someone on Oracle's forums just tried to use the WHERE clause to join instead of the JOIN statement and it worked. I tried it on and sure enough, it worked. It goes something like this:
FROM table1@remote JOIN table2@remote ON crap1 = poop1;
ERROR at line 1:
ORA-22992: cannot use LOB locators selected from remote tables
FROM table1@remote, table2@remote WHERE crap1 = poop1;
There is nothing we geeks hate more than code that should work but doesn't. Especially when the people we work for are paying five, six, seven or more figures for this software. The problem was originally noticed over two and a half years ago!