Information générale
Catégorie:
COM/DCOM et OLE Automation
Titre:
Using COM in SQL Server stored procedures
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
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement