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 2-21 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 2-21 Displaying stored procedures in a database

Figure 2-21  Displaying stored procedures in a database
4  
5  
*

Figure 2-22 Selecting a result set

Figure 2-22  Selecting a result set
*

Figure 2-23 Previewing output parameter values

Figure 2-23  Previewing output parameter values

(c) Copyright Actuate Corporation 2013