Can I configure ExecuteCallableStatement to return a String in one microflow and an Integer in another?

0
Hi all, I’m using the DatabaseConnector module and calling a stored procedure using the ExecuteCallableStatement Java action. I have a use case where I want to call the ExecuteCallableStatement in two different microflows: One microflow expects a String output The other expects an Integer output Can I configure the return type separately in each microflow depending on the expected output? Or is the return type fixed globally once set in the ExecuteCallableStatement configuration? Also, is it necessary to configure the return type in the ExecuteCallableStatement action (under Marketplace > DatabaseConnector > ExecuteCallableStatement) before using it in microflows? Also can we change the default return types of execute statement, execute parameterized query,etc?   Thanks in advance!
asked
1 answers
1

I think a better idea is to try and duplicate the java action and in one version you have a string return type and in the other you have an integer return type. 

 

Or if you really want only one action you could return an object with 2 different attribute types (String and Integer)

 

I am not sure about the end goal, the entire context of your problem. If the integer result that's already returned it's needed as a string maybe you could just reuse the same action but convert the integer result into a string result with the 'toString' method. If it's viceversa you could convert the string into an integer with the 'parseInteger' method.

 

Hope it helps :)

answered