Hi,
I am using ODI 12.2.1.4
I want to use variables in ODI load plans, however, when I set my alphanumeric variable to refresh mode in load plan (it has a code SELECT 'TEST' FROM DUAL; for refreshing) and run the load plan, the whole load plan does not execute. It doe not displayed in Operator either sessions. All variables work normally inside the packages.
Also, I ve tried to add at the beginning of the rootstep my variable and used a static value, marked with overwrite., but when I execute the load plan it throws NULL error for my variable. The same does not happen if I use number type for variable.
Is this a bug or Im missing something?
Thanks.