Skip to Main Content

SQL & PL/SQL

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!

How can i access Text, blob Datatype field from MySQL to Oracle

Bharath BallipongalaFeb 27 2019 — edited Mar 22 2022

We are currently working on 5.6 Version of MySQL.

pastedImage_0.png

I have a field which is a Text data type field in MySQL database.

pastedImage_1.png

We are using DBLINK to bring data across the wire.

We have a problem where we are not able to see the text field in the Oracle database.

pastedImage_2.png

Currently, we are using Oracle 11g version.

pastedImage_3.png

Can you please give us a suggestion about how can we get the text field from MySQL to Oracle, That will be more helpful.

Thank you in Advance.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 19 2022
Added on Feb 27 2019
13 comments
797 views