Executes a stored procedure in the database.

Required Parameters

• driver: The JDBC driver class name in the Java version or the ADO.NET provider name in the .NET version.
• conn: The connection string or database URL.
• sp: The name of the stored procedure.

Optional Parameters

• commandtimeout: CommandTimeout, in seconds, for the operation to complete. Zero (0) means no timeout. This attribute defaults to 60. The default value is 60.
• paramname#: The parameter names.
• paramvalue#: The parameter values.
• paramtype#: The parameter types.
• fromrow: Number of rows to skip from start. The default value is ‘0’.
• maxrows: Maximum number of rows to return from the database. Set to -1 to get all results. The default value is -1.
• querypassthrough: Pass the query to the operation as-is instead of performing client-side validation and syntax correction.

Output Attributes

• db:\: Output varies based upon the stored procedure.