PRB: Stored Procedure with Text (BLOB) Input Returns Null Output (178445)
The information in this article applies to:
- Microsoft Visual Basic Enterprise Edition for Windows 5.0
- Microsoft Visual Basic Enterprise Edition for Windows 6.0
This article was previously published under Q178445 SYMPTOMS When a stored procedure has a input text parameter (known
as BLOB, Binary Large Object), all the output parameters get set to Null by the
SQL Server on the way back to the client. CAUSE This is a known issue with SQL Server driver.
RESOLUTION Instead of using output parameters, prepare the returned
information in a resultset. STATUS Microsoft has confirmed this to be a bug in the Microsoft
products listed at the beginning of this article.
Modification Type: | Major | Last Reviewed: | 11/7/2003 |
---|
Keywords: | kbprb KB178445 |
---|
|