quote:

---

Msg 266, Niveau 16, État 2, Procédure InfoPrComplement, Ligne 0
Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 7, current count = 8.

(1 ligne(s) affectée(s))

(1 ligne(s) affectée(s))
Msg 3998, Niveau 16, État 1, Ligne 1
Uncommittable transaction is detected at the end of the batch. The transaction is rolled back.

---

BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
SET NOCOUNT ON;

----Verifier la valeur du titre
begin Try

	begin transaction

	Declare @Valeurtitre int;

	set @Valeurtitre = (select PAR_CATEGORIE.CAT_MONTANT 
	from CSR_DOSSIER,PAR_CATEGORIE 
	where CSR_DOSSIER.CAT_CODE = PAR_CATEGORIE.CAT_CODE 
	and CSR_DOSSIER.DOS_NODE = @node);

	Declare @Montantverser int;

	set @Montantverser = (Select SUM (dbo.CSR_COMPLEMENT.CMP_MTVERSE) 
	From dbo.CSR_COMPLEMENT WHERE dbo .CSR_COMPLEMENT.DOS_ID =(SELECT dbo.CSR_DOSSIER.DOS_ID 
	FROM dbo.CSR_DOSSIER 
	WHERE DOS_NODE =@node ));

	if (@Montantverser = @Valeurtitre )
	begin
		-----------resultat "Paiement complet"
		set @resultat = 'Paiement complet'; 
	end
	else
	begin
		SELECT dbo.CSR_DOSSIER.DOS_NOM +' '+ ISNULL ( dbo .CSR_DOSSIER.DOS_PRENOM, ' ') as Nom, 
		CSR_DOSSIER.PID_CODE +' - '+PAR_PIDENT.PID_LIB AS Poste , CSR_DOSSIER.TIT_CODE +' - '+ PAR_TITRE.TIT_LIB AS Titre ,
		CSR_DOSSIER.CAT_CODE, dbo.PAR_CATEGORIE.CAT_MONTANT,
		(Select SUM (dbo.CSR_COMPLEMENT.CMP_MTVERSE) 
		From dbo.CSR_COMPLEMENT WHERE dbo .CSR_COMPLEMENT.DOS_ID =(SELECT dbo.CSR_DOSSIER.DOS_ID 
		FROM dbo.CSR_DOSSIER 
		WHERE DOS_NODE =@node )) as MontantVerse 
		FROM dbo.CSR_DOSSIER ,dbo.PAR_CATEGORIE ,dbo.PAR_PIDENT, PAR_TITRE 
		WHERE dbo .CSR_DOSSIER.DOS_ID =(SELECT dbo.CSR_DOSSIER.DOS_ID 
		FROM dbo.CSR_DOSSIER WHERE DOS_NODE =@node )
		AND CSR_DOSSIER.CAT_CODE = PAR_CATEGORIE .CAT_CODE 
		AND CSR_DOSSIER.PID_CODE = PAR_PIDENT.PID_CODE 
		AND CSR_DOSSIER.TIT_CODE = PAR_TITRE.TIT_CODE; 
		set @resultat ='Paiement Partiel'; 
	end
	
	commit transaction

	return @resultat 
end try
begin catch
IF @@TRANCOUNT > 0 
	ROLLBACK TRANSACTION;

SELECT ERROR_PROCEDURE() AS ErrorProcedure ,ERROR_LINE() AS ErrorLine,ERROR_MESSAGE() AS ErrorMessage;
end catch

END

USE tempdb
GO

IF OBJECT_ID('foo') IS NOT NULL DROP PROCEDURE foo
GO

CREATE PROCEDURE foo @bar INT OUTPUT, @woo INT OUTPUT
AS BEGIN
	SET @bar = 3
	SET @woo = 5
	RETURN 55676
END
GO

DECLARE
	  @a INT
	, @b INT
	, @c INT

SELECT @a,@b,@c

-- Note that @c is not passed as OUTPUT
EXEC @a = dbo.foo @bar = @b OUTPUT, @woo = @c 

SELECT @a,@b,@c

Msg 3903.. The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION.