Delphi 5.0 + SQL Server 7.0 + Stored Procedure

I am using a TStoredProc to call a stored procedure in SQL Server.

When I get to the ExecProc method, I get an error message.

Does anybody have an idea about what the message "Indicator variable
required but not supplied" means ?

Here's the code I used:

DELPHI CODE:
procedure TfrmTransfert.ConnectToDatabase;
var  StoredProc1 : TStoredProc;
  Nb : Integer;
  Int1 : Integer;
  ErrorCode : Integer;
  ErrorString : string;
  sKeyword : string;
   str : string;
   param : TParam;
begin

 StoredProc1 := TStoredProc.Create (Application);
 StoredProc1.DatabaseName := 'MONMP2';

   with StoredProc1 do begin
    StoredProcName := 'GetNumeroFromId';

      try
         Params.CreateParam(ftInteger, 'RETURN_VALUE', ptResult);
         Params.CreateParam(ftInteger, '@p_id_in', ptInput);
         ParamByName('@p_id_in').AsInteger := 1;
         Params.CreateParam(ftString, '@p_numero_out', ptOutput);
         Params.CreateParam(ftInteger, '@p_apperrorid_out', ptOutput);
         Params.CreateParam(ftString,  '@p_apperrortext_out', ptOutput);

         ExecProc;

         Int1 := ParamByName('@p_int1_out').AsInteger;
         ErrorCode := ParamByName('@p_apperrorid_out').AsInteger;
         ErrorString := ParamByName('@p_apperrortext_out').AsString;
    except
     ON E:EDatabaseError do begin
      str := E.message;
            ShowMessage(str);
   end;
    end;
      Params.RemoveParam(param);
  end; {with}

end;

SQL SERVER STORED PROCEDURE:

CREATE PROCEDURE GetNumeroFromId
 @p_id_in INTEGER,
 @p_numero_out VARCHAR(25) OUTPUT,
 @p_APPERRORID_out INT OUTPUT,
 @p_APPERRORTEXT_out VARCHAR(255) OUTPUT
 WITH RECOMPILE AS
BEGIN

 DECLARE @v_ERRORCODE INT
 SELECT @p_numero_out = numero FROM vehicules WHERE Id = @p_Id_in
 SELECT @v_ERRORCODE=@@ERROR

   IF (@v_ERRORCODE<>0)
      SELECT @p_numero_out = ''
 RETURN 0
END

Any help would be appreciated !

--
Eric Langlois
E-Mail : Eric.Langl...@com-bacc.com
Tlphone : (514) 890-6070