I have a VB object that I am instantiating in a stored procedure.
I set various properties, and then I call a method to do processing.
My object has an ErrorCount property that I check to see if there were any problems.
If ErrorCount > 0 then I want to get all of the error messages from the object...
My object has a variant property called ErrorData. This property contains a 2-dimensional array. Column 1 is an error number, and column 2 is the error description.

If I call ...
EXEC @hr = sp_OAGetProperty @oObject, 'ErrorData'

My error messages are returned as a result set.

The problem is...How do I access this result set? If I would like to save these errors in a log, or a table?


Phil