Need help with selecting wide Teradata colum through Oracle Transparent Gateway

Database

Need help with selecting wide Teradata colum through Oracle Transparent Gateway

Has anyone gotten this to work?  Apparently Oracle Transparent Gateway is trying to convert a character column defined as varchar(10000) -- only the first 999 characters are populatedm, but trim doesn't help -- OTG converts it to LONG.  The select / join gets an error -- illegal use of LONG datatype. 

Originally the user was getting "remote statement has unoptimized view with remote object", so they created a view that mirrors the Teradata view they're using...so now we have the new error above.

The column that's giving up the trouble is the first column in the table, and is defined as:

RANGE_STR VARCHAR(10000) CHARACTER SET LATIN CASESPECIFIC NOT NULL,

the query is a SELECT DISTINCT (no inserts involved).

Thanks in advance.

Tags (3)