FIX: AV Assigning Decimal from VIEW to OUTPUT Parameter (156862)
The information in this article applies to:
- Microsoft SQL Server 6.0
- Microsoft SQL Server 6.5
This article was previously published under Q156862
BUG #: 15623 (Windows NT: 6.0)
15860 (Windows NT: 6.5)
SYMPTOMS
Assigning a decimal value from a VIEW to an OUTPUT parameter of a stored
procedure causes a handled access violation (AV). The client reports the AV
message on SQL Server version 6.0, and appears to stop responding on SQL
Server version 6.5. The errorlog contains the details of the access
violation.
WORKAROUND
To work around this problem, do one of the following:
- Avoid assigning the decimal datatype OUTPUT parameter to a stored
procedure.
- Avoid using views; select directly from the underlying tables.
- Instead of using OUTPUT parameters, return values from the stored
procedure.
- Create a temporary table to hold the results of the SELECT statement.
Then assign the results to OUTPUT parameters, selecting data from the
temporary table.
STATUS
Microsoft has confirmed this to be a problem in Microsoft SQL Server
versions 6.0 and 6.5. This problem has been corrected in U.S. Service Pack
2 for Microsoft SQL Server version 6.5. For more information, contact your
primary support provider.
MORE INFORMATION
This problem happens only when the decimal value is selected from a view
and assigned to an OUTPUT parameter of a stored procedure. The process
is terminated by the server. On SQL Server 6.5, the client does not report
the error, so it appears to stop responding.
| Modification Type: | Major | Last Reviewed: | 10/16/2003 |
|---|
| Keywords: | kbBug kbfix kbnetwork KB156862 |
|---|
|