Page History

...

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:

sql-stored:classpath:sql/myprocedure.sql[?options]

Where sql/myprocedure.sql is a plain text file in the classpath with the template, as show:

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&...

...