I need to set an ODI variable (Var1) to another variable which can be different depending on the package; thus it could be Var2, Var 3 and so on.
It seems that I have two options:
- to set it to a fixed value
- to set it to different variable using a statement like SELECT DECODE (logic, value, #Var2, logic, value, #Var3, ....) FROM DUAL but this way I have to declare and set each variable to NULL which I think it is inconvenient.
Is there any other way much simpler? I don't know why I can't use an ODI variable as source for another ODI variable....