1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41
| CREATE
PROCEDURE [U_AIG].[PR_AIG_ADD_XML_INPUT]
@sender varchar(20),
@xml_type numeric(3,0),
@xml_data varchar(max)
AS
DECLARE @return_value int,
@sequence_value numeric(38, 0)
BEGIN
EXEC @return_value = [U_REF].[PR_REF_GET_NEXT_SEQUENCE_VALUE]
@schema_name = N'U_AIG',
@sequence_name = N'S_AIG_INPUT_EVTSUIVI',
@sequence_value = @sequence_value OUTPUT
INSERT INTO U_AIG.T_AIG_INPUT
(
U_AIG.T_AIG_INPUT.AIG_INPUT_VC_SENDER,
U_AIG.T_AIG_INPUT.AIG_INPUT_DT_POSTAGE,
U_AIG.T_AIG_INPUT.AIG_INPUT_NB_TRAITE,
U_AIG.T_AIG_INPUT.AIG_INPUT_CL_XMLDATA,
U_AIG.T_AIG_INPUT.AIG_INPUT_NB_TYPEXML,
U_AIG.T_AIG_INPUT.AIG_INPUT_NB_EVTSUIVI
)
VALUES
(
@sender,
getdate(),
0,
@xml_data,
@xml_type,
@sequence_value
)
IF (@@TRANCOUNT > 0)
COMMIT WORK
return @sequence_value
END |
Partager