title: Executing stored procedure in Java class
body: <p>I have a stored procedure that I want to execute within a Java class. I have the values of the stored procedure within the SQL of the procedure and want to be able to execute it fully in a Java class.<br/>
  Below is the stored procedure:</p>
  <pre><code>exec @sta = storedProcedureName
          @TFT = 'Value',
          @TFTRW = 'Value2',
          @TRTF_Num = 1,
  </code></pre>
  <p>Since I already have the full statement I tried to execute it using a prepared statement but got the below error:<br/></p>
  <pre><code>must declare variable @sta
  </code></pre>
  <p>Does anyone know how I can just execute the stored procedure above in my class or do I have to prepare a callable statement and substitute the values in as Strings and Ints?</p>