Microsoft KB Archive/136821

= PRB: DECLARE CURSOR on Table Created in Stored Proc Fails =

Article ID: 136821

Article Last Modified on 10/30/2003

-

APPLIES TO


 * Microsoft SQL Server 6.0 Standard Edition
 * Microsoft SQL Server 6.5 Standard Edition

-



This article was previously published under Q136821



SYMPTOMS
If you create a table in a stored procedure and reference it in a DECLARE CURSOR statement, execution of the stored procedure will fail with:

Msg 202, Level 11, State 2 "Internal error -- Unable to open table at query execution time."



WORKAROUND
You can avoid this error message by either creating the table before you create the stored procedure, or enclosing the DECLARE CURSOR statement inside an EXEC statement, such as: EXEC("DECLARE hC CURSOR FOR select * from pubs")



MORE INFORMATION
This error occurs with either temporary or permanent tables in SQL Server version 6.0. With SQL Server 6.5, it only occurs with a permanent table. This error does not occur in SQL Server 7.0 and SQL Server 2000.

This error occurs if the table is created with either CREATE TABLE or SELECT INTO.

Additional query words: sql6

Keywords: kbprogramming kbprb KB136821

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.