[HO define: Long fetch]

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

Hi.

Having never used this functionality I'm in no position to make an educated judgement, but is it possible that the reference to Long actualy relates to a LONG datatype? If so, are there any restrictions to the datatypes that can be accessed over the gateway?

Sounds like you might have to check out the manuals and/or raise a TAR with Oracle support to me.

Sorry I can't be of more help.

Tim...

thanks Tim

The problem seems to be with the gateway, we cant retrieve more than one text column. Our DBA is investigating

mark.