Hi,
We have a oracle sequence which has to be used for three target table(Oracle) columns,How could we call oracle sequence and pass the sequence generated value to them.
Thanks for your time
Thanks,
Sateesh
Calling oracle sequence
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 48
- Joined: Sat Oct 22, 2005 9:56 am
Hi Ray,
Thanks for your suggestion and i got to know how to call sequence value in target database,But the thing is that i want to generate the unique value for all the three target table columns ,How could i achieve this.
In my target insert query i am calling oracle sequence like seq.nextval.
Thanks,
Sateesh
Thanks for your suggestion and i got to know how to call sequence value in target database,But the thing is that i want to generate the unique value for all the three target table columns ,How could i achieve this.
In my target insert query i am calling oracle sequence like seq.nextval.
Thanks,
Sateesh
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: