How to use nest loop about ATP query in integration flow
Hi All,
I am a beginner of OIC.
Now I have 2 autonomous database tables stored data from 2 different system.
I'd like to compare one of their columns, if the are the same then invoke a integration.
So I plan to use 2 ATP connection with select table data.
Just like:
for i in (select * from table A ) loop
for j in (select * from table B where B .id=i.id ) loop
if j.xx=i.xx then
( call API )
end if
end loop
end loop
It seems the ATP connection with selection function don't have parameter, So I cannot achieve the above step B .id=i.id
Tagged:
0