ORA-01461

[pavan_test]

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

[pavan_test]

my dba says it is datastage problem since he is able to update/insert into the same database.

please give me suggestions

thanks
Mark

[pavan_test]

can anyone please give me advice me.

thanks
mark

[mystuff]

Looks like a mismatch of datatype.

In the oracle stage, you might be having a datatype for a field defined as long. But in the database same field is of different datatype.

[pavan_test]

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

[chulett]

Then it seems you need to report this as a bug, see if this is a known issue and if there is patch available for it.

[pavan_test]

i did not find any information regarding varchar in the release notes :(

Thanks
Mark

[pavan_test]

i did not find any information regarding varchar in the release notes :(

Thanks
Mark

[pavan_test]

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

[chulett]

I suggested you open a case with your official support provider, not read the release notes. Although that wasn't a bad idea but it certainly isn't the only thing to do.