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 thepane.
In the right pane, click theicon to open the tab.
Select theradio button for the .
In thepane, 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:
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.
Create properties for procedure results columns.
To map result columns to properties, specify the name of the result column for each property in thefield.