当前位置: 代码迷 >> Oracle开发 >> PLS-00103:看不出来有关问题,高手帮看上
  详细解决方案

PLS-00103:看不出来有关问题,高手帮看上

热度:172   发布时间:2016-04-24 07:14:51.0
PLS-00103:看不出来问题,高手帮看下
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