salut a vous les developpeurs !
voila, j'ai un souci lors de l'appel a une procedure stockée que voici : elle retourne la valeur null pour @id_pers!

merci de votre aide
CREATE PROCEDURE SelectRoleParForm  @id_ss_serv bigint, @id_form bigint, @wwid_pers varchar(50) AS
 declare @id_pers bigint
 set @id_pers=(select id_pers from personne where wwid_pers=@wwid_pers)
 if(@id_ss_serv = 0)
 begin
  select distinct *
  from formulaire, proposer_role, role, etre_attribue
  where formulaire.id_form=proposer_role.id_form AND proposer_role.id_role=role.id_role AND date_annul_role='01/01/1900' AND formulaire.id_form=@id_form
  AND role.id_role NOT IN (select id_role from etre_attribue where id_pers=@id_pers)
 end 
 else
 begin
  select distinct *
  from formulaire, proposer_role, role, sous_service, etre_attribue
  where formulaire.id_form=proposer_role.id_form AND proposer_role.id_role=role.id_role  AND date_annul_role='01/01/1900' AND formulaire.id_form=@id_form AND sous_service.id_ss_serv=role.id_ss_serv
AND role.id_role NOT IN (select id_role from etre_attribue where id_pers=@id_pers)
AND sous_service.id_ss_serv=@id_ss_serv
 end
GO