ORA-01461
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 263
- Joined: Fri Sep 23, 2005 6:49 am
ORA-01461
Hi All,
I am running a data stage job in 8.0.1. all my input and output stages are
oracle enterprise endition stages.
none my columns in my input and output stages are long or nchar or nvarchar
however wen i run my job it is aborting with this error at the output oracle stage;
sqlcode is: -1461
esql complaint: ORA-01461: can bind a LONG value only for insert into a LONG column
my OS is aix 5.3. data stage version 8.0.1. database 10g
please give me suggestions;
thanks
mark
I am running a data stage job in 8.0.1. all my input and output stages are
oracle enterprise endition stages.
none my columns in my input and output stages are long or nchar or nvarchar
however wen i run my job it is aborting with this error at the output oracle stage;
sqlcode is: -1461
esql complaint: ORA-01461: can bind a LONG value only for insert into a LONG column
my OS is aix 5.3. data stage version 8.0.1. database 10g
please give me suggestions;
thanks
mark
-
- Premium Member
- Posts: 263
- Joined: Fri Sep 23, 2005 6:49 am
Re: ORA-01461
my dba says it is datastage problem since he is able to update/insert into the same database.
please give me suggestions
thanks
Mark
please give me suggestions
thanks
Mark
-
- Premium Member
- Posts: 263
- Joined: Fri Sep 23, 2005 6:49 am
Re: ORA-01461
can anyone please give me advice me.
thanks
mark
thanks
mark
-
- Premium Member
- Posts: 263
- Joined: Fri Sep 23, 2005 6:49 am
ORA-01461
I verified the data types of all the columns in my datastage job (target stage:Oracle Enterprise Edition) and i did not find any column with data types long,nchar or nvarchar.
i also verified data types for all the columns in the target database table and none of them are long.
the data stage job is working fine in data stage 752 version but aborts in data stage 8.0.1 version.
Thanks
Mark
i also verified data types for all the columns in the target database table and none of them are long.
the data stage job is working fine in data stage 752 version but aborts in data stage 8.0.1 version.
Thanks
Mark
-
- Premium Member
- Posts: 263
- Joined: Fri Sep 23, 2005 6:49 am
ORA-01461
i did not find any information regarding varchar in the release notes :(
Thanks
Mark
Thanks
Mark
-
- Premium Member
- Posts: 263
- Joined: Fri Sep 23, 2005 6:49 am
ORA-01461
i did not find any information regarding varchar in the release notes :(
Thanks
Mark
Thanks
Mark
-
- Premium Member
- Posts: 263
- Joined: Fri Sep 23, 2005 6:49 am
Re: ORA-01461
Can anyone please suggest me if you have encountered such errors with oracle enterprise edition as target stage in 8.0.1 version. please suggest me what did you do to resolve it.
The same job was successful in data stage version 7.5.2
Thanks
Mark
The same job was successful in data stage version 7.5.2
Thanks
Mark