How to call stored Procedure /Function from Talend job ?

One Star

How to call stored Procedure /Function from Talend job ?

In Talend Job how to call stored Procedure or Function ?
Twelve Stars

Re: How to call stored Procedure /Function from Talend job ?

You can use special component for this tSP - change for proper, as example - https://help.talend.com/search/all?query=tOracleSP&content-lang=en
or as usual - from SQL command
-----------
One Star

Re: How to call stored Procedure /Function from Talend job ?

Thank you very much. The link for document is very helpful -- Thanks again
One Star

Re: How to call stored Procedure /Function from Talend job ?

Thank you very much vapukov, Unfortunately, we are using Postgress sql as our db-- Is there any documentation or any other way we can call Functions /SP from Postgress SQL db ?-- Thanks In advance
Twelve Stars

Re: How to call stored Procedure /Function from Talend job ?

Thank you very much vapukov, Unfortunately, we are using Postgress sql as our db-- Is there any documentation or any other way we can call Functions /SP from Postgress SQL db ?-- Thanks In advance

You can use tPostgresqlRow for call any SQL code, do it same as PostgreSQL console - plain SQL code
-----------
One Star

Re: How to call stored Procedure /Function from Talend job ?

So you are saying Past Function in Query area of tPostgresqlROW_1 ?