Reporting Assistant in Oracle

[badhri]

Greetings,

We run Datastage 4.2 in Unix.

I used the reporting assistant to update the metadata in to the Oracle Database. But when I try doing this Datastage throws an Oracle error message "TOO MANY VALUES".

Please help me with your inputs.

Thanks in Advance,
Badhri ...

[WoMaWil]

Compare the Access Tables with the Oracle Tables if the all have same fields.
Check if the reporting tool an Access work together.

Do you have NLS or not. There are also different versions.

Wolfgang

Greetings,

We run Datastage 4.2 in Unix.

I used the reporting assistant to update the metadata in to the Oracle Database. But when I try doing this Datastage throws an Oracle error message "TOO MANY VALUES".

Please help me with your inputs.

Thanks in Advance,
Badhri ...

[badhri]

Thanks for the inputs,

I will compare the Access tables and the Oracle tables. We have NLS enabled. Is their anything to be taken care for this ????.

Thanks,
Badhri ...