Analytics Software

Hi
I am trying to carry out a simple loop in ODI 11g, But somehow the loop gets into an infinite loop. Please give your suggestions..

I have created two variables:
TotalCount--->(DataType-Numeric)-->Action(Non_Persistent) -->Refreshing Tab(select count(*) from Investment table);
Counter-->(DataType-Number)-->Action(Non_Persistent)-->Refreshing Tab(select #Counter+1 from dual);
Var1-->(DataType-Number)-->Action(Latest_value)-->Refreshing Tab(select #TotalCount-#Counter from dual)

I have created a package where I have these variables that help in looping through the TotalCount and insert some dummy records into a table using a procedure.

Package --> TotalCount(I have made this as a DECLARE variable) -->Counter(I have made it a Refresh VARIABLE and default value is 0)-->Var1(I have made this as an refresh variable )-->Var1(I have made this as an Evaluate variable and in condtion ,i checked it with 0 )

if true then exit else go to again in loop
In the True path, I have an ODI procedure that inserts a dummy record into a table.




Any suggestions would really help


Thanks,