Hi,
I have set the data mapping for my Extract, transform, and load (ETL) from SQLText Management (odbc database) to Oracle and have ensured the schema on Oracle has the correct datatypes. Often records get rejected during the transformation stage because we will expect a column to be VARCHAR2(2000) for example based on all of the data we have analysed to date but new migrated data has changed and the same column increases to VARCHAR2(4000) for example.
When I start the package from Visual Importer the tables start to read but on the transformation stage I get the following error message displayed as below.
Error 28/06/2006 13:17:00 Record:47 Line:47 HY000 [Oracle][ODBC][Ora]ORA-01461: can bind a LONG value only for insert into a LONG column
Error 28/06/2006 13:18:18 Record:747 Line:747 HY000 [Oracle][ODBC][Ora]ORA-01461: can bind a LONG value only for insert into a LONG column
Error 28/06/2006 13:23:06 Record:1830 Line:1830 HY000 [Oracle][ODBC][Ora]ORA-01461: can bind a LONG value only for insert into a LONG column
Error 28/06/2006 13:23:20 Record:1860 Line:1860 HY000 [Oracle][ODBC][Ora]ORA-01461: can bind a LONG value only for insert into a LONG column
Error 28/06/2006 13:37:00 Record:3148 Line:3148 HY000 [Oracle][ODBC][Ora]ORA-01461: can bind a LONG value only for insert into a LONG column
Error 28/06/2006 13:59:36 Record:4689 Line:4689 HY000 [Oracle][ODBC][Ora]ORA-01461: can bind a LONG value only for insert into a LONG column
Can anyone suggest where to start after changing colum from a varchar to clob.
Regards,
Simon
