Hello,
I have been doing a ton of work connecting my Oracle 11.1.0.6 DB to o a MySQL 5.0.77 Database (Holds Bugzilla) via dg4odbc 11.2.0.2. With all the GREAT help from this forum I seem to only have one issue left and it is a "Show Stopper" for me.
I have a MySQL table that has columns in it defined as"mediumtext" when I select these columns from the Oracle side I get an ORA-00904.
This is the table I am testing with (Please take note of "thetext"):
CREATE TABLE `longdescs` (
`comment_id` mediumint(9) NOT NULL auto_increment,
`bug_id` mediumint(9) NOT NULL,
`who` mediumint(9) NOT NULL,
`bug_when` datetime NOT NULL,
`work_time` decimal(7,2) NOT NULL default '0.00',
`thetext` mediumtext NOT NULL,
`isprivate` tinyint(4) NOT NULL default '0',
`already_wrapped` tinyint(4) NOT NULL default '0',
`type` smallint(6) NOT NULL default '0',
`extra_data` varchar(255) default NULL,
PRIMARY KEY (`comment_id`),
KEY `longdescs_bug_id_idx` (`bug_id`),
KEY `longdescs_who_idx` (`who`,`bug_id`),
KEY `longdescs_bug_when_idx` (`bug_when`),
CONSTRAINT `fk_longdescs_bug_id_bugs_bug_id` FOREIGN KEY (`bug_id`) REFERENCES `bugs` (`bug_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `fk_longdescs_who_profiles_userid` FOREIGN KEY (`who`) REFERENCES `profiles` (`userid`) ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=18643 DEFAULT CHARSET=utf8;
When I issue my Query I get the error:
SQL> SELECT "comment_id", "bug_id", "thetext" FROM "longdescs"@BUGZ;
SELECT "comment_id", "bug_id", "thetext" FROM "longdescs"@BUGZ
*
ERROR at line 1:
ORA-00904: "thetext": invalid identifier