Skip to main content
New Participant
Sep 17, 2024 1:51 AM UTC
Solved

I cannot execute a stored procedure from a postgresql database

In a Process Model I have added an Execute Stored Procedure and configured everything very well, in Data in the data source I put the constant with the connected system, in the name of the procedure I put the correct one and I configure the 2 input variables of the procedure, save and it is published fine and when it is executed it returns the error: ERROR: insert_in_din_tbl_tests(character varying, integer) is a procedure Hint: To call a procedure, use CALL. Position: 15, I understand that by default the Execute Stored Procedure executes with CALL without any prior configuration, but rather it executes it by default, so I don't understand how to arrange my execution.
somasundaram.d
Employee
Sep 17, 2024 3:42 PM UTC

Try adding 

escapeSyntaxCallMode=callIfNoReturn 

(or) 

escapeSyntaxCallMode=call 

parameter to the connectionURL of the data source in the connected system.

6 replies

somasundaram.d
Employee
Sep 17, 2024 4:15 AM UTC

Can you provide the configuration screen shot

New Participant
Sep 17, 2024 10:42 AM UTC

Hi Soma, I'm going to provide a little more context.

somasundaram.d
Employee
Sep 17, 2024 3:42 PM UTC

Try adding 

escapeSyntaxCallMode=callIfNoReturn 

(or) 

escapeSyntaxCallMode=call 

parameter to the connectionURL of the data source in the connected system.

New Participant
Sep 17, 2024 5:31 PM UTC

Thank you very much master, I had my PostgreSQL Connection URL incomplete, I had: jdbc:postgresql://ownserverdb:5432/database_name and as you indicated, I was missing the escapeSyntaxCallMode=callIfNoReturn part at the end of the Connection URL, leaving it complete like this at the end: jdbc:postgresql://ownserverdb:5432/database_name?escapeSyntaxCallMode=callIfNoReturn and now I run the Stored procedure and it works! thank you so much:

somasundaram.d
Employee
Sep 17, 2024 5:34 PM UTC

Good to hear it.