Previous Next

How to use a stored procedure to retrieve data from a JDBC data source

This procedure assumes you have already created the JDBC data source that this data set uses.

1  
2  
1  
In Data Source Selection, select the JDBC data source to use.
2  
3  
Query displays a template for executing a stored procedure.
3  
Figure 3-3 shows a stored procedure selected in Available Items. The stored procedure has three parameters. The text area displays the call statement to run the stored procedure.

Figure 3-3 Displaying stored procedures in a database

Figure 3-3  Displaying stored procedures in a database
4  
5  
*

Figure 3-4 Selecting a result set

Figure 3-4  Selecting a result set
*

Figure 3-5 Previewing output parameter values

Figure 3-5  Previewing output parameter values

(c) Copyright Actuate Corporation 2013