DSXchange

Posted: **Wed Mar 07, 2007 3:11 am**

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

Posted: **Wed Mar 07, 2007 4:30 am**

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

Thanks
Athira

Posted: **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.

Posted: **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.

Posted: **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.

Posted: **Wed Mar 07, 2007 10:08 pm**

I have tried that out many a times

Posted: **Wed Mar 07, 2007 10:11 pm**

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

DSXchange

DataStage job - runtime error ORA-01036