topic Re: Script PL/SQL execute with component tsystem in Talend Studio

Script PL/SQL execute with component tsystem

JeremyTrtr — Fri, 15 Nov 2024 23:24:05 GMT

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 — Mon, 20 Dec 2021 14:20:24 GMT

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 — Tue, 21 Dec 2021 08:29:51 GMT

Hi,

The use of a tOracleRow answers my problem.

Thanks