PRB: DECLARE CURSOR on Table Created in Stored Proc Fails (136821)


The information in this article applies to:

  • Microsoft SQL Server 6.0
  • Microsoft SQL Server 6.5
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.

Modification Type:MajorLast Reviewed:10/30/2003
Keywords:kbprb kbprogramming KB136821
©2003 Microsoft Corporation. All rights reserved.