DataStage job - runtime error ORA-01036

kumar_s · Post by **kumar_s** » Wed Mar 07, 2007 3:11 am

Hi Athira, Do you think that the topic can be marked as Resolved..

AthiraM · Post by **AthiraM** » Wed Mar 07, 2007 4:30 am

Yes, I believe the topic can be marked as resolved.

Thanks
Athira

kumar_s · Post by **kumar_s** » Wed Mar 07, 2007 4:33 am

AthiraM wrote:Yes, I believe the topic can be marked as resolved.

If so, its you who need to do it.

chulett · Post by **chulett** » Wed Mar 07, 2007 7:55 am

AthiraM wrote:When using ODBC stages I did create user-defined query where sequences where used and it did work fine, in that case i didn't mention the column in the ODBC stage.

For the record, the ODBC stage isn't quite as 'picky' as the OCI stages when it comes to using all the columns you've defined. It will merrily let you define columns and not use them, whereas the OCI stage will force you to use every one that is mentioned in the column tab.

kumar_s · Post by **kumar_s** » Wed Mar 07, 2007 5:28 pm

You can find the button on the top of this post. If at all you are looking for one.

AthiraM · Post by **AthiraM** » Wed Mar 07, 2007 10:08 pm

I have tried that out many a times

kumar_s · Post by **kumar_s** » Wed Mar 07, 2007 10:11 pm

So now we should open a ticket for Webmaster to fix it up.