Custom RPC Operation
When you select the Use Custom Operations check box in the Request-Response Options tab, you can create a custom schema for your operations. You can define the call operations to be processed by the RPC server in advance. TIBCO Business Studio automatically generates the input and output schema for the call operation.
The following figure shows the configuration of the custom RPC mode:
The following table describes the request schema.
The following table describes the input options.
| Option | Data Type | Description |
|---|---|---|
| MAXROWS | Integer | The maximum number of rows to retrieve. |
| SQL | String | The SQL string uses to execute the stored procedure. This string is automatically generated by the palette. |
| CACHE | Boolean | True if users want the agent to cache the statement for performance optimization. |
| PACKAGE | String | Read only. Uses the call operation form to modify the package of the stored procedure. |
| SCHEMA | String | Read only. Uses the call operation form to modify the package of the stored procedure. |
The following table describes the reply schema.
| Output Item | Data Type or Class Name | Description |
|---|---|---|
| OUTBINDS | OUTPUT_BINDS | Output parameters of the stored procedure. |
| RESULTSET[1..n]/RESULTSETS | OUTPUT_ROWS/SQL_RESULTSET | The result set(s) returned by the stored procedure, see "Result Set Support" for more description. |
| STATUS | String | SUCCESS if the stored procedure is executed successfully.
FAILURE if there is an error. Error details are stored in the OPTIONS class. |
| OPTIONS | CUSTOM_OP_OUTPUT_OPTION | Contains the error description and the SQL statement if an error occurred. |
| CLOSURE | Any | Closure argument obtained from the request. |
Result Set Support
TIBCO ActiveMatrix Adapter for Database (TIBCO Business Studio) supports multiple resultsets returned for a stored procedure. The class generated for the resultset output depends on the schema information provided by the JDBC driver.
For drivers that return valid information of a resultset schema, TIBCO ActiveMatrix Adapter for Database (TIBCO Business Studio) creates an output class, named OUTPUT_ROW[1..n], for each result set.
If a driver does not return valid information for the resultset schema, TIBCO ActiveMatrix Adapter for Database (TIBCO Business Studio) uses the generic class SQL_RESULTSETS as the output schema, as described in Standard RPC Operation.