Script PL/SQL execute with component tsystem

[JeremyTrtr]

Hello,

I'm a beginner in Talend. I would like to run a PL/SQL script which is placed in a directory through the Tsystem component.

When I create my job and I run it, I don't get an error message but nothing happens either.

But when I execute the command directly in the cmd it's ok...

See below my job and the message after the execution

[Anonymous]

Can you take a look at these documents .....

https://community.talend.com/s/article/Can-I-execute-multiple-commands-at-one-time-with-a-tSystem-component-WdGpH

https://help.talend.com/r/en-US/8.0/system/tsystem

You will need to make sure that you follow the rules specified in the documents above and also check that the script has an output.

[JeremyTrtr · Accepted solution]

Hi,

The use of a tOracleRow answers my problem.

Thanks