Next you have to specify if the entity you are calling is a procedure or a function. This attribute is by default true for stored procedures and must be set to false if the entity you are calling is a function. The difference between a procedure and a function is that the function always has a return value. Inside your POJO class you have to define the stored procedure parameters call and to decorate the fields with @StoredProcedureParameter annotation. You have to specify the index of the parameter starting with 1 for the first parameter. The names of the parameters are not important because the parameters are accessed by index not by names. If the entity is a function the first parameter (index = 1) is always the return value. The next attribute is the SQL type of the parameter. Here you have to be carefully because you are just did a mapping of a SQL type to a Java type and this mapping must match. The last parameter is the direction attribute for this parameter which can be IN, OUT or INOUT. For a function result parameter you must specify always OUT as a direction attribute.

The next step is to create a ProcedureManager instance, set the input parameters on your POJO class and finally call the stored procedure. The ProcedureManager instance is created using the ProcedureManagerFactory.createInstance() method using a JBC Connection object as parameter or a class decorated with @JDBC annotation. If you need to use transactions a TransactionManager interface is available to use. Also all checked exceptions are converted to unchecked exceptions and its not mandatory to use a try catch block on your code.