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 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 databaseFigure 3-4 Selecting a result set
![]()
If the stored procedure returns output parameter values, choose Preview Output Parameters. Figure 3-5 shows an example of the values returned by the stored procedure shown in Figure 3-3.Figure 3-5 Previewing output parameter values
(c) Copyright Actuate Corporation 2013 |