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.
Oracle sequence issue
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 24
- Joined: Thu Jun 21, 2007 1:20 am
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.
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.
-
- Premium Member
- Posts: 24
- Joined: Thu Jun 21, 2007 1:20 am
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.
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.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
I've done this and it works 'fine' although it is not my preferred methodology.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: