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!

Retrieve data from the remote DB LONG column type

Pavel_pOct 6 2018 — edited Oct 7 2018

Hello,

I have a table in a remote database (11.2EE) that contains a LONG column (I know, LONG data type has been deprecated for more than 20 years but it's like that and unfortunately there is nothing I can do about it) that stores EDIFACT https://en.wikipedia.org/wiki/EDIFACT documents. I need to occasionally parse these documents which means to somehow get it over a DB link to my local DB (11gXE) first.

Any ideas how to retrieve LONG column contents from the remote database over a DB link would be highly appreciated.

Regards,

Pavel

This post has been answered by Gaz in Oz on Oct 7 2018

Jump to Answer

Added on Oct 6 2018

8 comments

5,243 views