Install, Upgrade, Clone, Patch - EBS (MOSC)

MOSC Banner

HOW CAN ACCESS COLUMN OF "TEXT" DATATYPE FRO NON ORACLE

edited Aug 20, 2021 9:08AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 1 commentAnswered

Hi database Experts,

I have established a db connection from oracle db 11 (ebs) with sqlite by dg4odbc in order to extract data from sqlite table. After successful extraction of data i am facing

issue in "TEXT" data type column , they are not accessible or identifiable by oracle.

suppose if i write sql query like "

SELECT *

        FROM fmaTransaction@sql_famw"

It gives me all columns and their data except columns are defined with "text" data type.

Please let me know how i can sort out this issue.

Thanks

Tagged:

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