Error when calling a PostgreSQL stored procedure using tdbRow - getting syntax error at end of input

[MRosol_ACS]

Hello,

Can someone point me in right direction concerning calling a PostgreSQL procedure in Talend. I am using the tpostresqlRow (which resolves to tdbRow), but no matter how I call the procedure in the SQL query field, I get the same error. 

This is the call in the Query box. The procedure has no parameter inputs.

"CALL set_status_running;"

This is the error:

"syntax error at end of input"

I'm sure it must be something simple, but so far it is eluding me and I can't find any answers in web searches.

Thank you!

[Denis_Segard]

Hello,

Could you test to use :

"CALL set_status_running()"

Kind regards
Denis

[MRosol_ACS]

Hello Denis, thank you for your response.

Calling the procedure with the parentheses returns this error: 

ERROR: procedure set_status_running() does not exist
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Position: 6
[ERROR] 15:36:43 erds_talend.mspubs_package_procedures_0_1.MSPUBS_Package_Procedures- tDBRow_1 - ERROR: procedure set_status_running() does not exist
Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.
Position: 6

If I remove the parentheses -- "CALL set_status_running" I get this error:

ERROR: syntax error at end of input
Position: 31
[ERROR] 15:34:30 erds_talend.mspubs_package_procedures_0_1.MSPUBS_Package_Procedures- tDBRow_1 - ERROR: syntax error at end of input
Position: 24

[Denis_Segard]

Hello,
1. The procedure exists ion the DB / Schema set in the component ? 

2. Else you can create a file c:/temp/logging.postgres.properties with the lines:

.level=INFO
handlers =java.util.logging.ConsoleHandler
java.util.logging.ConsoleHandler.level = ALL
java.util.logging.ConsoleHandler.formatter = java.util.logging.SimpleFormatter
sun.net.www.protocol.http.HttpURLConnection.level=ALL
# Facility specific properties.
org.postgresql.level = FINEST

then, execute the job with the JVM argument :
-Djava.util.logging.config.file=c:/temp/logging.postgres.properties

to get some traces from the Postgres JDBC Driver ...

Kind regards
Denis

[MRosol_ACS · Accepted solution]

Thank you Denis.

I worked with a Postgres developer who demonstrated how to get the procedure to work in the Postgres IDE. The problem was with how I set up the Talend connection. The procedures were implemented in a separate schema from the tables and I thought I needed a separate connection for that schema. (I didn't.)

Best regards,

Martin