Skip to Main Content

Load Plan Variables do not work

OnatGGJul 2 2021

I am using ODI
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?


This post has been answered by Christyxo on Jul 2 2021
Jump to Answer