DSXchange

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 meta data in target stage(oracle) as varchar(1500),varchar(1300),varchar(1300),varchar(1300), then data getting inserted.

My concern is whether Oracle will accept more than 1 column with Varchar2(1500) in one TABLE.

Thanks in Advance

To answer the question asked - yes, of course.

chulett wrote:To answer the question asked - yes, of course.

but when i ran the job i am getting the below error in the datastage

esql complaint: ORA-01461: can bind a LONG value only for insert into a LONG column

all source columns data type is varchar(1500) and respective target columns datatype is varchar2(1500)

We know, we've seen your other post. Have you run this by your Oracle DBA, see if they can shed any light on the issue?

i have taken meta data for the 4 columns in the Target oracle stage as varchar(1300),varchar(1300),varchar(1300),varchar(1300) and respective Target table columns (oracle data base) data type as Varchar2(1500),Varchar2(1500),Varchar2(1500),Varchar2(1500), i ran the job, it is fine and data also geeting inserted.

Then as Ray would say - time to mark your post as Resolved then?