Hi Friends,
i Configured a HS to connect a mysql database from oracle .
I made some select on this database by dblink to mysql , but some columns are long type ( text at mysql ) and i cant read this columns by the oracle .
somebody have any idea to make this , Below have a EX .
insert
into
cfttx_ordem( ID, ORDEM, EMPRESA, BAL, TECNICO, USUARIO, STATUS, TIPO, TIPO2, PERIODO,hora)
select
"id" AS ID,
"ordem" AS ORDEM,
"empresa" AS EMPRESA,
"bal" AS BAL,
"tecnico" AS TECNICO,
"usuario" AS USUARIO,
"status" AS STATUS,
"tipo" AS TIPO,
"tipo2" AS TIPO2,
"periodo" AS PERIODO,
"hora"
from ordem@fttx
where "ordem" = 5653142;
Then show this message error :
"ORA-00997: illegal use of LONG datatype"
this , because one column in this case ( hora ) is a long data type at mysql table .
[]`s