Windows Oracle Data Access Components (MOSC)

MOSC Banner

Unable to query MySQL mediumtext from Oracle using HSODBC

edited Sep 25, 2013 3:37AM in Windows Oracle Data Access Components (MOSC) 3 commentsAnswered
Hi there,I hope this post finds you well.
This post is for ask your help with a problem we're experimenting right now.
Recently we had to create an Oracle database link to a vendor MySQL database for reporting purposes. Now the database link it seems be working, and we can do queries to the database tables. The problem here is that one of the most important values that we need for the reports is stored at MySQL as mediumtext, and every time we include this kind of field on our queries or when we query it directly, we received this error message:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center