topic Re: Calling a Postgresql stored procedure using tdbRow in Talend Studio

Calling a Postgresql stored procedure using tdbRow

MRosol_ACS — Wed, 16 Jul 2025 18:30:23 GMT

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

Re: Calling a Postgresql stored procedure using tdbRow

Dave_Simo — Thu, 17 Jul 2025 07:31:49 GMT

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

Re: Calling a Postgresql stored procedure using tdbRow

MRosol_ACS — Wed, 23 Jul 2025 17:00:52 GMT

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