THIS IS A TEST INSTANCE. ALL YOUR CHANGES WILL BE LOST!!!!
...
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&...
...