Execute a plsql block in talend but in synchronous mode

Careau — Thu, 29 Jun 2023 18:55:24 GMT

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

Re: Execute a plsql block in talend but in synchronous mode

Anonymous — Fri, 30 Jun 2023 08:08:14 GMT

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