Calling a Postgresql stored procedure using tdbRow

[MRosol_ACS]

How do I set up a tPostgresqlRow (tdbRow) to capture the output of a stored procedure's OUT or INOUT variables? I've tried various "tricks" but nothing seems to work.

This would not be a challenge if tdbSP existed for Postgres. But unfortunately, it is not supported.

Thank you,

Martin

[Dave_Simo]

Hello @MRosol_ACS 

Since there is no tdbSP component to call stored procedures from a Postgre database, I think you can find a way to do it with the tJDBCSP component using a JDBC connection

Source : https://help.qlik.com/talend/fr-FR/components/8.0/jdbc/tjdbcsp

Best reagrds

[MRosol_ACS]

Thank you for the tip, Dave_Simo. It gets me part of the way.

The connection to Postgres is working, but the call is failing. The message returned by Postgres indicates that the Talend is not calling the procedure correctly. Possibly tDBSP's JDBC implementation is not compatible with Postgres.

[FATAL] 12:46:01 erds_talend.proc_test_0_1.PROC_TEST- tDBSP_1 (org.postgresql.util.PSQLException) ERROR: package.lg_mr_test(character varying, character varying, integer, character varying) is a procedure
Hint: To call a procedure, use CALL.
Position: 15

I've tried different tricks, to test how Talend constructs the call, but no luck. Maybe a fix in a future release?

Regards