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.