Solved

I cannot execute a stored procedure from a postgresql database

Forum|Forum|1 year ago
September 17, 2024
6 replies
0 views

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.

Best answer by somasundaram.d

Try adding

escapeSyntaxCallMode=callIfNoReturn

(or)

escapeSyntaxCallMode=call

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

somasundaram.d

Can you provide the configuration screen shot

H

harrisonm0313Author

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

somasundaram.dAnswer

Try adding

escapeSyntaxCallMode=callIfNoReturn

(or)

escapeSyntaxCallMode=call

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

H

harrisonm0313Author

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

Good to hear it.

Sign up

Login with SSO

Login to the community

Login with SSO