This Confluence has been LDAP enabled, if you are an ASF Committer, please use your LDAP Credentials to login. Any problems file an INFRA jira ticket please.

Child pages
  • SQL Stored Procedure

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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

...