...
Where template is the stored procedure template, where you declare the name of the stored procedure and the IN and OUT arguments.
You can also refer to the template in a external file on the file system or classpath such as:
Code Block |
---|
sql-stored:classpath:sql/myprocedure.sql[?options] |
Where sql/myprocedure.sql is a plain text file in the classpath with the template, as show:
Code Block |
---|
SUBNUMBERS(
INTEGER ${headers.num1},
INTEGER ${headers.num2},
OUT INTEGER resultofsub
) |
You can append query options to the URI in the following format, ?option=value&option=value&...
...