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 In Data Source Selection, select the JDBC data source to use.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 databaseFigure 2-22 Selecting a result set
![]()
If the stored procedure returns output parameter values, choose Preview Output Parameters. Figure 2-23 shows an example of the values returned by the stored procedure shown in Figure 2-21.Figure 2-23 Previewing output parameter values
(c) Copyright Actuate Corporation 2013 |