Support out parameters on stored procedures

[ryaneberly]

<script connection-id="db"> call GETINFO( ?Prefix , ?PolicyNumber , ?); </script>

This fails when JDBC attempts to call the procedure. We often use a single output parameter to track error conditions.
It would great if the the procedure would be called w/o error, better still if there was a way to put the result into a variable.

[ejboy]

Thank you for bringing it up. This was raised several times already and I'm going to implement it. It will be based on the JDBC escape syntax defined in CallableStatement:

{?= call <procedure-name>[(<arg1>,<arg2>, ...)]}
{call <procedure-name>[(<arg1>,<arg2>, ...)]}

[ryaneberly]

Wonderful - I'm happy to help test it.
Scriptella's a great tool.

[ejboy]

Actually I was able to use output parameters after calling a stored procedure in mysql. See example at http://stackoverflow.com/a/26725585/1129542