ORA-00997: illegal use of LONG datatype error when query from oracle to mysql over dblink

I created a db link from Oracle (19c) to MySQL (8.0). My MySQL table's columns datatypes are text (I mustn't change the datatype). There are 126 columns in the table (It must be such). When I try to query to MySQL in oracle sqlplus it gives "ORA-00997: illegal use of LONG datatype" error. I tried to many thing including creating a view in MySQL with casted fields to char or varchar but not solve the problem. When I do "desc view_table@dblink" in oracle sqlplus columns are still appeared as long datatype. Is there a way to solve it? What can I do? I stucked here.