Using the Procedure Provider API

SQLFire provides an API to help you develop data-aware procedures. A ProcedureExecutionContext object provides information about the table used to filter the procedure execution, colocated data, and other information about the context in which a procedure is executed. An OutgoingResultSet interface enables you to construct a result set by adding rows or columns to a List object.

Use the information in this section to develop and compile your procedure, and then add the implementation to SQLFire using the instructions in Storing and Loading JAR Files in SQLFire. You can then configure and execute the procedure using the information in Using Data-Aware Stored Procedures.