For everyone else still struggling with this error...
On 10g I have found a workaround that works for smaller linked tables. The table that was causing the problem was a link to a link on another server. I now create a temp table and copy the whole linked table to the server I am on at the beginning of my proc. Then, instead of the linked table I use the temp table and my proc works.