Surrogate_Key_Generator

daniele · Post by **daniele** » Tue Oct 16, 2012 3:58 am

Hi ,
I used Surrogate_Key_Generator with source oracle sequence,but
I need also sequence.currval , how can I do it?

jerome_rajan · Post by **jerome_rajan** » Tue Oct 16, 2012 4:59 am

You need to be more elaborate.

daniele · Post by **daniele** » Tue Oct 16, 2012 5:20 am

In loop Condition I use If (MyCondition)Then SurrogateKeyGen else
"current val of sequence oracle"

SurrogateKeyGen generate correctly nextval of sequence but in expression

how can I get "current val of sequence oracle" ?

Thanks

chulett · Post by **chulett** » Tue Oct 16, 2012 5:30 am

You really should have it stored somewhere, failing that you could select CURRVAL rather than NEXTVAL from your sequence.

DSXchange

Surrogate_Key_Generator

Surrogate_Key_Generator

Re: Surrogate_Key_Generator