Oracle sequence issue

rohitchattar · Post by **rohitchattar** » Mon Jan 28, 2008 11:02 pm

We have upgraded our server edition from 7.5 to 7.5.2. What is the difference between these two versions?
We have checked all the possibilities suggested by chulett and ray but did't get nay set up difference with our existing system.

We have the prob only with whenever we are calling the oracle sequence from oracle stage. We are using oracle stage with reference link without any key column. Is this causing the prob?

Please suggest.

chulett · Post by **chulett** » Mon Jan 28, 2008 11:04 pm

Suggest you open a case with your official Support provider at this point if you truly can't find any differences between the two servers.

And no, that kind of reference lookup without a key field is not a problem.

rohitchattar · Post by **rohitchattar** » Mon Jan 28, 2008 11:06 pm

We have upgraded our server edition from 7.5 to 7.5.2. What is the difference between these two versions?
We have checked all the possibilities suggested by chulett and ray but did't get nay set up difference with our existing system.

We have the prob only with whenever we are calling the oracle sequence from oracle stage. We are using oracle stage with reference link without any key column. Is this causing the prob?

Please suggest.

rohitchattar · Post by **rohitchattar** » Mon Jan 28, 2008 11:07 pm

We have upgraded our server edition from 7.5 to 7.5.2. What is the difference between these two versions?
We have checked all the possibilities suggested by chulett and ray but did't get nay set up difference with our existing system.

We have the prob only with whenever we are calling the oracle sequence from oracle stage. We are using oracle stage with reference link without any key column. Is this causing the prob?

Please suggest.

ray.wurlod · Post by **ray.wurlod** » Tue Jan 29, 2008 12:54 am

It is impossible - on either system - to have a reference link without a key column. How would you specify which row(s) to return?

chulett · Post by **chulett** » Tue Jan 29, 2008 1:02 am

Actually, it's not impossible. For an Oracle sequence, you simply use a query of "select X.NEXTVAL from DUAL" with a single non-key column to hold the result. No key is supplied in the reference link and it returns a new key for every record through the job.

I've done this and it works 'fine' although it is not my preferred methodology.

ray.wurlod · Post by **ray.wurlod** » Tue Jan 29, 2008 1:10 am

OK, not impossible, but insane if the reference column has many rows.