title: The text, ntext, and image data types are invalid for local variables
body: <p>How do I fix this error?</p>
  
  <pre><code>The text, ntext, and image data types are invalid for local variables.
  </code></pre>
  
  <p>My proc is:</p>
  
  <pre><code>set ANSI_NULLS ON
  set QUOTED_IDENTIFIER ON
  GO
  ALTER PROCEDURE [dbo].[GetJobInfo]
      (
      @jobId int,
      @subject varchar(50) OUTPUT,
      @Body ntext OUTPUT,
      @prepared_email_id int OUTPUT
      )
  AS
  BEGIN
      SET NOCOUNT ON
      SELECT TOP 1 @prepared_email_id = p.[PreparedEmailID],
          @subject = p.[Subject],
          @Body = p.[Body]
          FROM [PreparedEmails] p INNER JOIN
          [Jobs] j ON p.[PreparedEmailID] =
          j.[PreparedEmailID]
          WHERE j.[JobID] = @jobId
      RETURN
  END
  </code></pre>
  
  <p>I don't know what the error is or how I fix it.
  Please help me...</p>