Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Problem Selecting a "mediumtext" Column from MySQL using dg4odbc

Sky13Dec 22 2011 — edited Mar 1 2012
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 29 2012
Added on Dec 22 2011
12 comments
1,431 views