Sequence number in Oracle DB

shilpa79 · Post by **shilpa79** » Wed Apr 04, 2007 12:37 pm

Do we have any function for generating the sequence number in Oracle
in PX.

Thanks,

chulett · Post by **chulett** » Wed Apr 04, 2007 12:56 pm

Be more specific. Are you referring to leveraging an Oracle sequence object, the kind of thing you would 'select x.nextval from dual' to use?

If so, why not just use the Surrogate Key Generator stage?

Madhusv · Post by **Madhusv** » Wed Apr 04, 2007 4:24 pm

There are routines KeyMgtGetNextValue and KeyMgtGetNextValueConcurrent, You can use this to genrate sequence in server jobs

DSguru2B · Post by **DSguru2B** » Wed Apr 04, 2007 5:03 pm

Madhusv wrote:There are routines KeyMgtGetNextValue and KeyMgtGetNextValueConcurrent, You can use this to genrate sequence in server jobs

The routines mentioned above will help you if you are on server edition.
If px, the follow Craig's advice. As both the advices are specific to the edition your working on.

shilpa79 · Post by **shilpa79** » Mon Apr 09, 2007 12:20 pm

DSguru2B wrote:
Madhusv wrote:There are routines KeyMgtGetNextValue and KeyMgtGetNextValueConcurrent, You can use this to genrate sequence in server jobs
The routines mentioned above will help you if you are on server edition.
If px, the follow Craig's advice. As both the advices are specific to the edition your working on.

I tried in server with the above two key translomations its working fine and I have used surrogatekey stage in PX it also worked fine.

Thanks for all your help

ray.wurlod · Post by **ray.wurlod** » Mon Apr 09, 2007 3:01 pm

Watch this space.