Great! Thanks for that, and thanks for bearing with me on this one guys.
On Mon, Jan 3, 2011 at 8:24 PM, Chris Morgan
>> Just for completeness I am posting the script to create the stored
>> procedure, I'd like to know what about the statement requires
>> multistatements to be set to true.
>> Multiple-result processing also is required if you execute CALL statements
>> for stored procedures. Results from a stored procedure have these
>> Statements within the procedure may produce result sets (for example, if
>> it executes SELECT statements). These result sets are returned in the order
>> that they are produced as the procedure executes.
>> In general, the caller cannot know how many result sets a procedure will
>> return. Procedure execution may depend on loops or conditional statements
>> that cause the execution path to differ from one call to the next.
>> Therefore, you must be prepared to retrieve multiple results.
>> The final result from the procedure is a status result that includes no
>> result set. The status indicates whether the procedure succeeded or an error