CREATE PROCEDURE SP_UserPayment
(
IN @BinNumber VARCHAR(5),
IN @VANUMBER VARCHAR(16),
IN @TRACENO VARCHAR(6),
IN @TRNDATE VARCHAR(10),
IN @AMOUNT AS DECIMAL,
IN @currency VARCHAR(3),
IN @DELCHANNEL VARCHAR(3),
IN @terminalId varchar(8),
IN @Reference VARCHAR(20),
OUT @responseCode VARCHAR(2) ,
OUT @ResponseMessage VARCHAR(30)
)
AS
BEGIN
START TRANSACTION;
SET NOCOUNT on
--implemet sp
COMMIT
END;
?