data insert error in oracle

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
vinodn
Charter Member
Charter Member
Posts: 93
Joined: Tue Dec 13, 2005 11:00 am

data insert error in oracle

Post by vinodn »

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
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

To answer the question asked - yes, of course.
-craig

"You can never have too many knives" -- Logan Nine Fingers
vinodn
Charter Member
Charter Member
Posts: 93
Joined: Tue Dec 13, 2005 11:00 am

Long data type issue

Post by vinodn »

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)
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

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?
-craig

"You can never have too many knives" -- Logan Nine Fingers
vinodn
Charter Member
Charter Member
Posts: 93
Joined: Tue Dec 13, 2005 11:00 am

Post by vinodn »

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.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

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

"You can never have too many knives" -- Logan Nine Fingers
Post Reply