[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 188
  • Last Modified:

What is wrong with this SQL SP that it keeps giving me a Cursorfetch error?

I keep getting  this error with the code example below.  I've looked at a million times and I must be missing something.  Maybe a fresh pair of eyes can spot the obvious mistake.  Thank you!  This is urgent!

ex = {"Cursorfetch: The number of variables declared in the INTO list must match that of selected columns."}
USE [OrderEntry_prodSQL]
GO
/****** Object:  StoredProcedure [dbo].[InsertBOLTransfer]    Script Date: 04/06/2009 12:49:25 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
ALTER PROCEDURE [dbo].[InsertBOLTransfer]
--(@Bolnum nvarchar(25), @HeatID int)
 
AS
 
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;
   -- DECLARE @BLNum as nvarchar(25)
DECLARE @Control as int
DECLARE @HeatID as int
DECLARE @CoilNumber as nvarchar(25)
 
DECLARE @FinishedSize as nvarchar(15)
DECLARE @Grade as nvarchar(15)
DECLARE @HeatNumber as nvarchar(20)
DECLARE @TotalWeight as int
DECLARE @NoOfCoils as int
DECLARE @VendorName as nvarchar(25)
DECLARE @RodSize as nvarchar(10)
DECLARE @VendorPO as nvarchar(15)
DECLARE @VendorNumber as int
--DECLARE @DateReceived as smalldatetime
DECLARE @ID as int
 
    DECLARE CoilsCursor CURSOR FAST_FORWARD FOR
	 SELECT     Control,HeatNumber,Grade,FinishedSize,SUM(Weight) AS TotalWeight,COUNT(*) AS NoOfCoils,HeatID,VendorName,VendorPO,RodSize,HeatID,VendorNumber
		FROM         tblPickList
        GROUP BY tblPickList.Control, tblPickList.HeatNumber, tblPickList.Grade, tblPickList.HeatID, tblPickList.FinishedSize,VendorName,VendorPO,RodSize,VendorNumber
	OPEN CoilsCursor
FETCH NEXT FROM CoilsCursor INTO @Control,@HeatNumber,@Grade,@FinishedSize,@TotalWeight,@NoOfCoils,@HeatID,@VendorName,@VendorPO,@RodSize,@VendorNumber
 
WHILE @@FETCH_STATUS = 0
BEGIN
    
    --PRINT 'Coil: ' +@CoilNumber
INSERT INTO tblBOLTransfer
(
Control,
HeatID,
HeatNumber,
Grade,
FinishedSize,
NetWeight,
NoOfCoils,
VendorName,
VendorPO,
RodSize,
VendorNumber
)
 
VALUES
(
@Control,
@HeatID,
@HeatNumber,
@Grade,
@FinishedSize,
@TotalWeight,
@NoOfCoils,
@VendorName,
@VendorPO,
@RodSize,
@VendorNumber
)
 
SELECT @ID =@@IDENTITY
FROM tblBOLTransfer
 
	FETCH NEXT FROM CoilsCursor INTO @Control,@HeatNumber,@Grade,@FinishedSize,@TotalWeight,@NoOfCoils,@HeatID,@VendorName,@VendorPO,@RodSize,@VendorNumber
	
 
END
 
CLOSE CoilsCursor
DEALLOCATE CoilsCursor
 
--DELETE FROM tblReceiving WHERE BOLNumber = @Bolnum

Open in new window

0
jvalescu
Asked:
jvalescu
  • 2
1 Solution
 
udaya kumar laligondlaTechnical LeadCommented:
DECLARE CoilsCursor CURSOR FAST_FORWARD FOR
       SELECT    
 Control,
HeatNumber,
Grade,
FinishedSize,
SUM(Weight) AS TotalWeight,
COUNT(*) AS NoOfCoils,
HeatID,
VendorName,
VendorPO,
RodSize,
HeatID,
VendorNumber
            FROM         tblPickList
        GROUP BY tblPickList.Control, tblPickList.HeatNumber, tblPickList.Grade, tblPickList.HeatID, tblPickList.FinishedSize,VendorName,VendorPO,RodSize,VendorNumber
      OPEN CoilsCursor
FETCH NEXT FROM CoilsCursor
INTO
@Control,
@HeatNumber,
@Grade,
@FinishedSize,
@TotalWeight,
@NoOfCoils,
@HeatID,
@VendorName,
@VendorPO,
@RodSize,
@VendorNumber
 
you are selecting one more than the no of variables
0
 
udaya kumar laligondlaTechnical LeadCommented:
HeatID is missing in the selection list or is added extra at the into part
 
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now