HOW CAN ACCESS COLUMN OF "TEXT" DATATYPE FRO NON ORACLE
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