DSXchange

Hi All,

Trying to load

Source column data type varchar2(4000)---Sql server

Target column data type is Varchar2(4000)---Oracle,

Datastage throws an error with the following

ORA_AUWREQUESTRESPONSE_Tab,0: Array execute failed for insert:
insert is: INSERT
INTO
AUWREQUESTRESPONSE
(AUWHISTORYID, REQUEST, RESPONSE)
VALUES
( :AUWHISTORYID, :REQUEST, :RESPONSE)
sqlcode is: -1461
esql complaint: ORA-01461: can bind a LONG value only for insert into a LONG column

Double-check your data types in each database. SQL Server doesn't have a 'varchar2' as far as I know and the error implies that your Oracle target column is a LONG not a VARCHAR2.

Check this link http://www.techonthenet.com/oracle/errors/ora01461.php

Hi all



in my source 4 columns data type is varchar(1500)---SQL server
Target 4 columns data type is Varchar2(1500)--Oracle

when i ran the job i am getting the as error ora:1461 LONG data type value is not insert in to another data type value,

if i take the target columns as varchar2(1500),varchar2(200),varchar2(300),varchar2(400), then data is inserted, only i am getting the error all the four columns in the target Varchar2(1500)

Regards
Ramesh

Thread Hijack Alert!

Welcome aboard. Your problem is not the same as the one for this thread, which is about parameter arrays.

Please begin a new thread with your question, which is about LONG data type. You might even save yourself that work by undertaking a Search to see whether it has already been answered.