title: SQL Procedure has no parameters and arguments were supplied
body: <p>So here is the code for the stored procedure and my execution. I keep getting this message when I try to execute my command: </p>
  
  <blockquote>
    <p>Msg 8146, Level 16, State 2, Procedure sp_LabelFilm, Line 0<br>
    Procedure sp_LabelFilm has no parameters and arguments were supplied.</p>
  </blockquote>
  
  <p>Any idea why? I am trying to update a column in the table tblfilm to say if a movie is short, medium, or long based on its run time. </p>
  
  <pre><code>ALTER PROCEDURE [dbo].[sp_LabelFilm]
  AS
  BEGIN
      DECLARE @Minutes INT, @duration char(10)
  
      DECLARE Filmcursor CURSOR FOR 
          (SELECT filmruntimeminutes, Duration FROM tblFilm)
  
      OPEN filmcursor
  
      FETCH NEXT FROM filmcursor INTO @duration
  
      WHILE (@@FETCH_STATUS = 0)
      BEGIN
          SELECT @Minutes = FilmRunTimeMinutes FROM tblFilm
  
          IF @Minutes &lt; 120 
              SET @duration = 'short' 
          ELSE IF @Minutes &lt; 150
              SET @duration = 'medium'
          ELSE
              SET @duration = 'long'
  
          FETCH NEXT FROM filmcursor INTO @duration
  
          UPDATE tblFilm 
          SET Duration = @duration
      END
  
      CLOSE filmcursor
      DEALLOCATE filmcursor
  END
  
  
  
  DECLARE @Minutes INT, @duration CHAR(10)
  
  EXECUTE [dbo].[sp_LabelFilm] @minutes, @duration
  </code></pre>