It is possible to query a database using stored procedures rather than building a query using the steps described previously.
To define a query from a stored procedure:
Select an element in the
pane.In the right pane, click the
icon to open the tab.Select the
radio button for the .Click the
tab.In the
pane, specify the execute statement for the procedure invocation.Oracle stored procedures use “out” parameters to return values and must be handled in a special way. The execute statement must be:
call procedure_name(?)
where procedure_name is the name of the stored procedure. The question mark represents the out cursor parameter to use for Data Integrator. If the procedure has multiple parameters, fill them in normally; just use a question mark for the out parameter.
Click the
tab.Create properties for procedure results columns.
To map result columns to properties, specify the name of the result column for each property in the
field.