CREATE OR REPLACE PROCEDURE spUpdMGCommissionType

(

v_CommissionTypeId  VARCHAR2 ,--not null,手续费率分类.手续费分类ID,CommissionType

v_CommissionTypeName          VARCHAR2,--NULL,手续费率分类.手续费率类别名称,CommissionType

v_BuyOpenAmountCommission      NUMBER,--NULL,席位手续费率.开仓按金额手续费率,SeatCommissionPercent

v_BuyOpenNumCommission        NUMBER,--NULL,席位手续费率.开仓按手数手续费率,SeatCommissionPercent

v_BuyCloseAmountCommission      NUMBER,--NULL,席位手续费率.平仓按金额手续费率,SeatCommissionPercent

v_BuyCloseNumCommission        NUMBER,--NULL,席位手续费率.平仓按手数手续费率,SeatCommissionPercent

v_BuyCloTodHedAmouComm    NUMBER,--NULL,席位手续费率.平今按金额手续费率,SeatCommissionPercent

v_BuyCloseTodayNumCommission      NUMBER,--NULL,席位手续费率.平今按手数手续费率,SeatCommissionPercent

v_BuyOpHedAmouComm    NUMBER,--NULL,席位手续费率.开仓按金额手续费率,SeatCommissionPercent

v_BuyOpenHedgeNumCommission      NUMBER,--NULL,席位手续费率.开仓按手数手续费率,SeatCommissionPercent

v_BuyCloHedAmouComm    NUMBER,--NULL,席位手续费率.平仓按金额手续费率,SeatCommissionPercent

v_BuyCloseHedgeNumCommission         NUMBER,--NULL,席位手续费率.平仓按手数手续费率,SeatCommissionPercent

v_BuyCloTodHedAmouComm NUMBER,--NULL,席位手续费率.平今按金额手续费率,SeatCommissionPercent

V_BUYCLOSTODHEDNUMCOMM    NUMBER,--NULL,席位手续费率.平今按手数手续费率,SeatCommissionPercent

v_SellOpenAmountCommission      NUMBER,--NULL,席位手续费率.开仓按金额手续费率,SeatCommissionPercent

v_SellOpenNumCommission        NUMBER,--NULL,席位手续费率.开仓按手数手续费率,SeatCommissionPercent

v_SellCloseAmountCommission      NUMBER,--NULL,席位手续费率.平仓按金额手续费率,SeatCommissionPercent

v_SellCloseNumCommission        NUMBER,--NULL,席位手续费率.平仓按手数手续费率,SeatCommissionPercent

V_SELCLOSTODAMOCOMM    NUMBER,--NULL,席位手续费率.平今按金额手续费率,SeatCommissionPercent

v_SellCloseTodayNumCommission    NUMBER,--NULL,席位手续费率.平今按手数手续费率,SeatCommissionPercent

V_SELOPHEDAMOUCOMM      NUMBER,--NULL,席位手续费率.开仓按金额手续费率,SeatCommissionPercent

v_SellOpenHedgeNumCommission         NUMBER,--NULL,席位手续费率.开仓按手数手续费率,SeatCommissionPercent

v_SelCloHedAmouComm     NUMBER,--NULL,席位手续费率.平仓按金额手续费率,SeatCommissionPercent

v_SellCloseHedgeNumCommission        NUMBER,--NULL,席位手续费率.平仓按手数手续费率,SeatCommissionPercent

v_SelCloTodHedAmouComm NUMBER,--NULL,席位手续费率.平今按金额手续费率,SeatCommissionPercent

v_SelCloTodHedNumComm   NUMBER,--NULL,席位手续费率.平今按手数手续费率,SeatCommissionPercent

v_DeliveryAmountCommission      NUMBER,--NULL,席位手续费率.交割按金额手续费率,SeatCommissionPercent

v_DeliveryNumCommission        NUMBER,--NULL,席位手续费率.交割按手数手续费率,SeatCommissionPercent

v_IsCover              NUMBER

)

AS

  sql1 VARCHAR2(2000);

BEGIN



  DECLARE

  err NUMBER;

  v_count NUMBER;

  sql1 :='select count(1)  from commissiontype where CommissionTypeId=:1' ;

  EXECUTE IMMEDIATE sql1 USING v_CommissionTypeId RETURNING INTO v_count;

  COMMIT;



  IF (