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.
Discussion posts and replies are publicly visible
Can you provide the configuration screen shot
Hi Soma, I'm going to provide a little more context.
Try adding
escapeSyntaxCallMode=callIfNoReturn
(or)
escapeSyntaxCallMode=call
parameter to the connectionURL of the data source in the connected system.
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:
Good to hear it.
Hi Soma, I have the same problem, I added the "?escapeSyntaxCallMode=callIfNoReturn" at the end of the string but it doesn't work, It seems that no query works