Hello All,
I am using select '<%=odiRef.getSession("SESS_NO")%>' from dual this query to get the session number but we are reusing this variable in all the packages and defining it in our first step as refresh variable in every package that we are using and calling the variable name as session_id.I am not saving this variable in any table but need to hold this until the package finish successfully if not I have to pass this variable as parameter in the email package that is designed to get the operator information.
I am having issues when I run one package and if I start other package in between then its having trouble as other package is overwriting the variable.
I have designed in an assumption that when I start the package the variable will be locked in the session and will not have any issue when I use same variable in other package but looks like my assumption was wrong.
Can anyone suggest how to use the same variable concurrently when we start 5 packages at the same time.
I am Using ODI 12c version 12.2.1.2.6 please feel free to ask if you need more details to resolve this issue.