Pentaho Data Integration STEP:BD Procedure Call

website Link: http://wiki.pentaho.com/display/EAI/Call+DB+Procedure Description

Calling the database stored procedure step allows the user to execute a database stored procedure and obtain the results. Stored procedures or methods can only return data through their parameters, and the output parameters must be defined in the database stored procedure parameters.

F&q

1. After setting the completion DB Procedure call, the error cannot find the corresponding stored procedure

After clicking the "Find it ..." button in Proc-name, the character in the Proc-name text box is databasename.procedure, and if you use SQL, you only need to write Procedure can be.

2. Execute SQL Server procedure incoming parameter execution error

Spoon when executing DB Procedure call requires incoming parameters, it needs to be passed in order according to the order of the parameters required by the stored procedure.

3. Execute SQL Server procedure unknown error

The spoon execution DB Procedure Call has a getmoreresults () error because there is a SELECT statement output data in the stored procedure, which is fine except for the SELECT statement.

4. Parameters's direction has in,out,inout option

In is the input parameter, out is the output parameter option, the INOUT option can be input and output

Pentaho Data Integration STEP:BD Procedure Call