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
data insert error in oracle
Moderators: chulett, rschirm, roy
Long data type issue
but when i ran the job i am getting the below error in the datastagechulett wrote:To answer the question asked - yes, of course.
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)
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.