select distinct long

Toad Data Point
1

Hi

I attempting to do a distinct select on a number of columns including one of type long. I get the following message:

Oracle Database Error: ORA-00997: illegal use of LONG datatype

So I then tried the long_to_char function and received the following message:

Oracle Database Error: ORA-20000: ORU-10027: buffer overflow, limit of 20000 bytes

So I thought I could then go and increase the serveroutput. I’ve not been able to work out how to do that in Toad for Data Analysts.

Any ideas?

Thanks