DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
This topic is not resolved, but there is a WORKAROUND.
Author Message
vinodn


since May 2006

Group memberships:
Premium Members

Joined: 13 Dec 2005
Posts: 93

Points: 683

Post Posted: Thu Jan 10, 2008 5:59 am Reply with quote    Back to top    

DataStage® Release: 7x
Job Type: Parallel
OS: Unix
Additional info: LONG data type
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

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 42585
Location: Denver, CO
Points: 219186

Post Posted: Thu Jan 10, 2008 8:37 am Reply with quote    Back to top    

To answer the question asked - yes, of course.

_________________
-craig

And I'm hovering like a fly, waiting for the windshield on the freeway...
Rate this response:  
Not yet rated
vinodn


since May 2006

Group memberships:
Premium Members

Joined: 13 Dec 2005
Posts: 93

Points: 683

Post Posted: Thu Jan 10, 2008 9:10 am Reply with quote    Back to top    

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)
Rate this response:  
Not yet rated
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 42585
Location: Denver, CO
Points: 219186

Post Posted: Thu Jan 10, 2008 10:05 am Reply with quote    Back to top    

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

And I'm hovering like a fly, waiting for the windshield on the freeway...
Rate this response:  
Not yet rated
vinodn


since May 2006

Group memberships:
Premium Members

Joined: 13 Dec 2005
Posts: 93

Points: 683

Post Posted: Fri Jan 11, 2008 2:27 am Reply with quote    Back to top    

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.
Rate this response:  
Not yet rated
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 42585
Location: Denver, CO
Points: 219186

Post Posted: Fri Jan 11, 2008 7:41 am Reply with quote    Back to top    

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

_________________
-craig

And I'm hovering like a fly, waiting for the windshield on the freeway...
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours