Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone
In my job, I need to call an Oracle function in the database.
I'm using the TDBRow. It's working fine but the next component is executed juste after my function event if it's not completed.
There's a way to make the call but wait the completing of the function before executing the next component ?
Other than create a tWait component after and check for a flag in a table or whatever ?
Thanks
Hello,
Are you able to get some return value from your oracle function?
If so, you could use the runIf connector to fire the step2, for example, let's assume that the return code is 1 when successful, 0 when failed.
tOracleRow--main-->tJavaRow--runIf--step2
on tJavaRow:
if(input_row.return_code==1){
globalMap.put("isContinue",true);
}else{
globalMap.put("isContinue",false);
}
set the condition of runIf link:
(Boolean)globalMap.get("isContinue")
Hope it will be helpful for your use case.
Best regards
Sabrina