Is it necessary to check all the input parameters/fields for a Database Call Procedure activity in Cast Iron Studio?

Technote (FAQ)


Is Cast Iron Studio required to pass all parameters in a Database Call Procedure?


No, Cast Iron Studio is not required to pass all parameters in a Database Call Procedure. The interface allows the selection of all parameters or some of the parameters as seen in the following screen shots:

This as well with omissions:

Omissions between selections are not allowed, as seen in the following screen shot, and will generate an error in runtime or a logical error where the stored procedure will return an unexpected result.

As shown above, the WORKSPACE parameter is omitted. Since it is a parameter that is between two selected parameters on the list (STAGING_TABLE AND WHERE_CLAUSE), this will result in either a logical error or functional error.

Rate this page:

(0 users)Average rating

Document information

More support for:

WebSphere Cast Iron Cloud integration

Software version:

Operating system(s):


Software edition:

Cloud, Physical, Virtual

Reference #:


Modified date:


Translate my page

Machine Translation

Content navigation