Page 1 of 1

Reporting Assistant in Oracle

Posted: Wed Aug 28, 2002 11:17 pm
by 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 ...

Posted: Thu Aug 29, 2002 3:42 am
by 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 ...


Posted: Thu Aug 29, 2002 10:00 pm
by 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 ...