Problem: Oracle LONG column field with table join

Question

Hello, I have two tables in Oracle 9i which I am trying to query with a table join, and I am experiencing some problem with one of the column which is type long. The problem is that if I query with a join e.g. assume t1.activity is type long and the query string is select t1.activity from table1 t1, table2 t2, where t1.id=t2.id; I will only get 100 chars or so back from this query, while the full value is about 1000 char long. However, if I do select t1.activity from table1 t1 where t1.id=x; I will get the full 1000 char long value back. Is there a way around this? I will have to make a lot of separate queries if the join doesn't work. p.s. using dataset.fill ( ) to through dataAdapter to get my values. using oracle ole db driver. thank you in advance for any feedback. -Ed