Problem while inserting data into oracle table

[vinodn]

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

[chulett]

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.

[dspxlearn]

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

[rameshn]

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

[ray.wurlod]

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.