How to call stored Procedure /Function from Talend job ?

[Anonymous]

In Talend Job how to call stored Procedure or Function ?

[vapukov]

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

[Anonymous]

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

[Anonymous]

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

[vapukov]

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

[Anonymous]

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