From a database connection
in the workbench, you can right-click
tables, views, aliases, materialized query tables, and stored procedures
to generate pureQuery code.
Generating pureQuery code from stored procedures
If a stored procedure has parameters, you can generate
a bean that represents those parameters. If the stored procedure returns
result sets, you can generate a bean for each result set. You can
also generate code in support of the annotated-method and inline programming
styles.