1 Reply Latest reply: Dec 23, 2013 6:15 AM by mkirtley-Oracle RSS

Oracle 11.2 x Mysql HS => ORA-00997:illegal use of LONG datatype

Zander Newbie
Currently Being Moderated

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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points