You specify and control the operation of the ProcedureCall bean by opening the property
sheet for the ProcedureCall bean and setting the value of the displayed properties. To
open the property sheet of a ProcedureCall bean on the Visual Composition Editor surface:
- Right click the ProcedureCall bean. The bean menu displays.
- Click Properties. The Properties sheet displays.

You can control:
- The name of the ProcedureCall bean. Specify the name as the beanName property
value.
- Whether to enable inserts, updates, and deletes for result sets which contain which
contain user-defined (distinct) types. Specify this in the distinctTypesEnabled
property value. Check the Show Expert Features checkbox to display this
property.
- Whether as many rows as possible should be fetched into the cache as soon as you execute
your stored procedure or rows should be fetched only as you ask for them. Specify this in
the fillCacheOnExecute property value. Check the Show Expert
Features checkbox to display this property.
- Whether as many result sets as possible should be fetched into the cache as soon as you
execute your stored procedure (given your settings for the above properties), or result
sets should be fetched only as you ask for them. Specify this in the fillResultCacheOnExecute
property value. Check the Show Expert Features checkbox to display this
property.
If you set this property to true, it is advisable to set the fillCacheOnExecute
property to true as well. Otherwise, there may be rows in the result sets, other than the
last result set, that can never be fetched.
- Whether to force generation of searched rather than positioned SQL UPDATE and DELETE
statements for result sets returned by the stored procedure. Specify this in the forceSearchedUpdate.
property value. Check the Show Expert Features checkbox to display this
property.
- Whether to acquire and hold a database lock for a row while it is the current row.
Specify this in the lockRows property value. Check the Show Expert Features
checkbox to display this property.
- The maximum number of packets allowed in the cache at one time for each result set. (Older
packets may be displaced as newer packets are fetched.) Specify this in the maximumPacketsInCache
property value. Check the Show Expert Features checkbox to display this
property.
- The maximum number of result sets allowed in the cache at one time. (Older result sets may
be displaced as newer ones are fetched.) Specify this in the maximumResultsInCache
property value. Check the Show Expert Features checkbox to display this
property.
- The maximum number of rows you can fetch into the cache over time. Specify this in the maximumRows
property value. Check the Show Expert Features checkbox to display this
property.
- The number of rows in a packet. Specify this
in the packetSize property value. Check the Show Expert Features
checkbox to display this property.
- The database connection characteristics and SQL statement. Specify these as a composite
value for the procedure property. See Specifying a
Connection and SQL Statement.
- Whether the result set is updatable. Specify this in the readOnly property value.
- The maximum number of seconds allowed for the statement to execute. Specify this in the timeout
property value. The default is 0, which means no maximum. Check the Show Expert Features checkbox to display this
property.
Specifying a connection and SQL statement.
ProcedureCall
