DB-LINK to mysql [message #658609] |
Wed, 21 December 2016 12:51 |
|
iliyan_84@abv.bg
Messages: 18 Registered: May 2016 Location: Bulgaria
|
Junior Member |
|
|
Hi,
I have a oracle 11g Release 11.2.0.1.0 datebase with dblink to mysql 5.5.38 and for programming i use PL/SQL Release 11.2.0.1.0. I can make selects from oracle to mysql but some columns from mysql can`t be select (missing). I mark that the missing columns are with type text.What is wrong in this situation and how to fix it
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Re: DB-LINK to mysql [message #658658 is a reply to message #658655] |
Thu, 22 December 2016 11:09 |
|
iliyan_84@abv.bg
Messages: 18 Registered: May 2016 Location: Bulgaria
|
Junior Member |
|
|
SQL> desc "Didtable"@gpsinfo;
Name Null? Type
----------------------------------------- -------- ----------------------------
DID NOT NULL NUMBER(20)
GroupID NUMBER(20)
OwnerID NUMBER(20)
AutomobileID NUMBER(20)
OwnNumber NVARCHAR2(100)
SmsNumber NVARCHAR2(100)
DatacallNumber NVARCHAR2(100)
ServiceNumber NVARCHAR2(100)
ProfileID NUMBER(20)
version NUMBER(20)
email NVARCHAR2(255)
is_fictive NOT NULL NUMBER(10)
*BlackSwan added {code} tags. Please do so yourself in the future.
How to use {code} tags and make your code easier to read
[Updated on: Thu, 22 December 2016 14:21] by Moderator Report message to a moderator
|
|
|
|
|
Re: DB-LINK to mysql [message #658667 is a reply to message #658661] |
Thu, 22 December 2016 14:17 |
Solomon Yakobson
Messages: 3275 Registered: January 2010 Location: Connecticut, USA
|
Senior Member |
|
|
joy_division wrote on Thu, 22 December 2016 14:09You have two completely different tables.
Not really. Some ODBC drivers skip columns they can't handle. Both missing columns (Name & Notes) are text and longtext which apparently ODBS driver can't handle. Some ODBC drivers have parameters for that. E.g. EasySoft SQL Server ODBC driver has VarMaxAsLong = Yes/No. It could be OP needs to set proper parameters.
SY.
|
|
|
Re: DB-LINK to mysql [message #658669 is a reply to message #658667] |
Thu, 22 December 2016 15:38 |
joy_division
Messages: 4963 Registered: February 2005 Location: East Coast USA
|
Senior Member |
|
|
Solomon Yakobson wrote on Thu, 22 December 2016 15:17joy_division wrote on Thu, 22 December 2016 14:09You have two completely different tables.
Not really. Some ODBC drivers skip columns they can't handle. Both missing columns (Name & Notes) are text and longtext which apparently ODBS driver can't handle. Some ODBC drivers have parameters for that. E.g. EasySoft SQL Server ODBC driver has VarMaxAsLong = Yes/No. It could be OP needs to set proper parameters.
Looks like I completely misread that posted info. I thought there were two completely different tables in the describe in SQL*Plus vs. describe in the other tool. I make many dumb mistakes reading some of these questions.
|
|
|
|
|
Re: DB-LINK to mysql [message #658701 is a reply to message #658700] |
Fri, 23 December 2016 07:25 |
|
iliyan_84@abv.bg
Messages: 18 Registered: May 2016 Location: Bulgaria
|
Junior Member |
|
|
SQL> desc "DidTable"@gpsinfo
Name Null? Type
----------------------------------------- -------- ----------------------------
DID NOT NULL NUMBER(20)
GroupID NUMBER(20)
OwnerID NUMBER(20)
AutomobileID NUMBER(20)
OwnNumber NVARCHAR2(100)
SmsNumber NVARCHAR2(100)
DatacallNumber NVARCHAR2(100)
ServiceNumber NVARCHAR2(100)
ProfileID NUMBER(20)
version NUMBER(20)
email NVARCHAR2(255)
is_fictive NOT NULL NUMBER(10)
SQL> spool off;
|
|
|