Execute a plsql block in talend but in synchronous mode

[Careau]

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

[Anonymous]

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