PRB: How to Use sp_displayoaerrorinfo in the sp_OA Samples

ID: Q151602

The information in this article applies to:

SYMPTOMS

The sp_OA procedure samples use the sp_displayoaerrorinfo procedure. However, the correct procedure is sp_OAGetErrorInfo.

Here is a corrected example: 


EXEC @hr = sp_OACreate 'SQLOLE.SQLServer', @object OUT
IF @hr <> 0
    EXEC sp_OAGetErrorInfo @object


MORE INFORMATION

The ssp_displayoaerrorinfo procedure is not installed by default. If you prefer to use the wrapped stored procedure, the text of the sp can be found in the HRESULT return codes section of the "Books Online."

Additional query words: sproc 


Keywords          : kbprg SSrvStProc kbbug6.50 
Version           : 6.5
Platform          : WINDOWS 
Issue type        :

Last Reviewed: March 27, 1999