I get the same error when run the following query:

FETCH name_cur INTO @dbName, @tableName

WHILE @@Fetch_Status = 0

BEGIN

SET @sql -....

insert into [dbo].[Table1] (obj_name, obj_type)

EXEC (@sql)

UPDATE [dbo].[Table1] SET db_name = @dbName ,table_name = @tableName WHERE db_name IS NULL

FETCH name_cur INTO @dbName, @tableName

END

CLOSE name_cur

DEALLOCATE name_cur

Can anybody help, why the error comes in the above query?