5450 error, when trying to insert Oracle table with NULL value
Recently we upgraded the Teradata database from 5380, V2R18.104.22.168 TO 5450,V2R6.00.02
and I have a problem when i'm trying to run the Insert script from ORACLE(connecting to Teradata database) procedure
where I'm trying to pull 'NULL' record from TERADATA table and insert into ORACLE table(with NULL columns).
"INSERT INTO DW_FIDM_INFO,ORA-28500: connection from ORACLE to a non-Oracle system returned this message: [Transparent gateway for TERA][NCR][ODBC Teradata Driver] Invalid precision: cbColDef value out of range (SQL State: S11; CD_STATUS:A"
Is this error related to new version of teradata? The same script did worked without any issue in the older version of Teradata.