Page 1 of 1
Surrogate_Key_Generator
Posted: Tue Oct 16, 2012 3:58 am
by daniele
Hi ,
I used Surrogate_Key_Generator with source oracle sequence,but
I need also sequence.currval , how can I do it?
Re: Surrogate_Key_Generator
Posted: Tue Oct 16, 2012 4:59 am
by jerome_rajan
You need to be more elaborate.
Posted: Tue Oct 16, 2012 5:20 am
by daniele
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
Posted: Tue Oct 16, 2012 5:30 am
by chulett
You really should have it stored somewhere, failing that you could select CURRVAL rather than NEXTVAL from your sequence.