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 (v_count=0) THEN
       err:=99999;
  ELSE
   BEGIN
      SET  v_CommissionTypeNameEn IS NULL;
      UPDATE CommissionType
      SET CommissionTypeName=v_CommissionTypeName,
          CommissionTypeNameEn=v_CommissionTypeNameEn,
          Flag=0 ,
          UpdateDT=SYSDATE
      WHERE CommissionTypeId=v_CommissionTypeId;      IF  v_IsCover=0    THEN
       update ContractCommission
       set BuyOpenAmountCommission         =NVL(v_BuyOpenAmountCommission,1)        ,
       BuyOpenNumCommission                 =NVL(v_BuyOpenNumCommission,1)         ,
       BuyCloseAmountCommission             =NVL(v_BuyCloseAmountCommission,1)     ,
       BuyCloseNumCommission               =NVL(v_BuyCloseNumCommission,1)        ,
       BuyCloseTodayAmountCommission       =NVL(v_BuyCloTodHedAmouComm,1),
       BuyCloseTodayNumCommission           =NVL(v_BuyCloseTodayNumCommission,1)   ,
       BuyOpenHedgeAmountCommission         =NVL(v_BuyOpHedAmouComm,1)       ,
       BuyOpenHedgeNumCommission           =NVL(v_BuyOpenHedgeNumCommission,1)         ,
       BuyCloseHedgeAmountCommission       =NVL(v_BuyCloHedAmouComm,1)     ,
       BuyCloseHedgeNumCommission           =NVL(v_BuyCloseHedgeNumCommission,1)       ,
       BuyCloTodHedAmouComm                 =NVL(v_BuyCloTodHedAmouComm,1),
       BuyCloTodHedNumComm                 =NVL(V_BUYCLOSTODHEDNUMCOMM,1)   ,
       SellOpenAmountCommission             =NVL(v_SellOpenAmountCommission,1)        ,
       SellOpenNumCommission               =NVL(v_SellOpenNumCommission,1)     ,
       SellCloseAmountCommission           =NVL(v_SellCloseAmountCommission,1)       ,
       SellCloseNumCommission               =NVL(v_SellCloseNumCommission,1),
       SellCloseTodayAmountCommission       =NVL(V_SELCLOSTODAMOCOMM,1)   ,
       SellCloseTodayNumCommission         =NVL(v_SellCloseTodayNumCommission,1)     ,
       SellOpenHedgeAmountCommission       =NVL(V_SELOPHEDAMOUCOMM,1)         ,
       SellOpenHedgeNumCommission           =NVL(v_SellOpenHedgeNumCommission,1)     ,
       SellCloseHedgeAmountCommission       =NVL(v_SelCloHedAmouComm,1)        ,
       SellCloseHedgeNumCommission         =NVL(v_SellCloseHedgeNumCommission,1),
       SelCloTodHedAmouComm                =NVL(v_SelCloTodHedAmouComm,1)  ,
       SelCloTodHedNumComm                 =NVL(v_SelCloTodHedNumComm,1)      ,
       DeliveryAmountCommission             =NVL(v_DeliveryAmountCommission,1)  ,
       DeliveryNumCommission               =NVL(v_DeliveryNumCommission,1)     ,
       Flag                                 =0                      ,
       IsCover                             =0,
       UpdateDT                             =SYSDATE
       WHERE CommissionTypeId=v_CommissionTypeId;
  ELSE
       update ContractCommission
       set BuyOpenAmountCommission         =NVL(v_BuyOpenAmountCommission,1)  ,
       BuyOpenNumCommission                 =NVL(v_BuyOpenNumCommission,1)  ,
       BuyCloseAmountCommission             =NVL(v_BuyCloseAmountCommission,1)  ,
       BuyCloseNumCommission               =NVL(v_BuyCloseNumCommission,1)    ,
       BuyCloseTodayAmountCommission       =NVL(v_BuyCloTodHedAmouComm,1),
       BuyCloseTodayNumCommission           =NVL(v_BuyCloseTodayNumCommission,1) ,
       BuyOpenHedgeAmountCommission         =NVL(v_BuyOpHedAmouComm,1) ,
       BuyOpenHedgeNumCommission           =NVL(v_BuyOpenHedgeNumCommission,1)   ,
       BuyCloseHedgeAmountCommission       =NVL(v_BuyCloHedAmouComm,1)  ,
       BuyCloseHedgeNumCommission           =NVL(v_BuyCloseHedgeNumCommission,1) ,
       BuyCloTodHedAmouComm                 =NVL(v_BuyCloTodHedAmouComm,1),
       BuyCloTodHedNumComm                 =NVL(V_BUYCLOSTODHEDNUMCOMM,1)   ,
       SellOpenAmountCommission             =NVL(v_SellOpenAmountCommission,1)   ,
       SellOpenNumCommission               =NVL(v_SellOpenNumCommission,1)     ,
       SellCloseAmountCommission           =NVL(v_SellCloseAmountCommission,1)     ,
       SellCloseNumCommission               =NVL(v_SellCloseNumCommission,1),
       SellCloseTodayAmountCommission       =NVL(V_SELCLOSTODAMOCOMM,1)   ,
       SellCloseTodayNumCommission         =NVL(v_SellCloseTodayNumCommission,1)    ,
       SellOpenHedgeAmountCommission       =NVL(V_SELOPHEDAMOUCOMM,1)         ,
       SellOpenHedgeNumCommission           =NVL(v_SellOpenHedgeNumCommission,1)     ,
       SellCloseHedgeAmountCommission       =NVL(v_SelCloHedAmouComm,1)        ,
       SellCloseHedgeNumCommission         =NVL(v_SellCloseHedgeNumCommission,1),
       SelCloTodHedAmouComm                =NVL(v_SelCloTodHedAmouComm,1)  ,
       SelCloTodHedNumComm                 =NVL(v_SelCloTodHedNumComm,1)      ,
       DeliveryAmountCommission             =NVL(v_DeliveryAmountCommission,1)  ,
       DeliveryNumCommission               =NVL(v_DeliveryNumCommission,1)     ,
       Flag                                 =0                      ,
       UpdateDT                             =SYSDATE
       WHERE  CommissionTypeId=v_CommissionTypeId
       AND  IsCover=0;
       END IF;
    END;
    END IF;
    END;
 PLS-00103: Encountered the symbol "=" when expecting one of the following:       constant exception <an identifier>     <a double-quoted delimited-identifier> table long double ref     char time timestamp interval date binary national character     nchar