title: Procedure sp_Get-- has no parameters and arguments were supplied
body: <p>I am getting the error "Procedure sp_Get--  has no parameters and arguments were supplied".
  I am calling a simple stored-proc from a CF component.</p>
  
  <p>The Stored proc is as follows</p>
  
  <pre><code>GO ALTER PROCEDURE [dbo].[sp_GetTest]
    @TestId INT AS BEGIN
    SET NOCOUNT ON;
  
    SELECT T.TestId
          ,T.TestDetail
          ,T.isPassedTest     
      FROM Test T     
     WHERE T.TestId = @TestId
  ORDER BY T.TestDetail
  
  END
  </code></pre>
  
  <p>I am calling it in CF8 component/method in the following manner:-</p>
  
  <pre><code>&lt;cffunction name="GetTest" returntype="query" access="public" output="false"&gt;
    &lt;cfargument name="Test" type="......Test.Test" required="true"&gt;
    &lt;cfstoredproc procedure="sp_GetTest" datasource="#variables.datasource#"&gt;
      &lt;cfprocparam cfsqltype="CF_SQL_INTEGER" value="#arguments.Test.GetTestId()#"&gt;           
      &lt;cfprocresult name="theTest" resultset="1"&gt;
    &lt;/cfstoredproc&gt;
  
    &lt;cfscript&gt;return theTest;&lt;/cfscript&gt;
  &lt;/cffunction&gt;
  </code></pre>
  
  <p>Kindly help me in debugging the error!
  Thanks </p>