I have a view in sybase that retrives data from several text columns. I've created a view in oracle (10g) to access the sybase view over a gateway. When I query the oracle view I get the error message

[HO define: Long fetch]

The sybase view works fine, but I cant retrive anything from the oracle view. One possibility I explored was that the text columns contained more than 4000 chars, but after examining the sybase results, there were just a few lines, certainly nowhere near 4000 chars.

can anyone give me some pointers ?

tia