PLS-00103:看不出来问题，高手帮看下

禅院小沙弥 2012-12-03 09:08:59 
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
...全文
180 4 打赏 收藏 转发到动态 举报
写回复
用AI写文章
4 条回复
切换为时间正序
请发表友善的回复…
发表回复
禅院小沙弥 2012-12-03
  • 打赏
  • 举报
 回复
引用 3 楼 sunneyting 的回复:
所有的标示符太长了
好像是要不超过30个字符吧，这个已经处理过的呢
南平 2012-12-03
  • 打赏
  • 举报
 回复
所有的标示符太长了
禅院小沙弥 2012-12-03
  • 打赏
  • 举报
 回复
貌似不行哦！
ssqtjffcu 2012-12-03
  • 打赏
  • 举报
 回复
sql1 :='select count(1) from commissiontype where CommissionTypeId=:1' ; 后加个begin ,最后面再加个end;
oracle报错00306,定义请求报错：ORA-06550 PLS-00306 请高手帮忙
我在系统定义了一个存储存储如下： PROCEDURE inv_czjk_sjjc(p_date_from IN VARCHAR2, p_date_to IN VARCHAR2, P_ORGANIZATION_ID IN NUMBER ) is l_... 请高手给看看我的错误在哪里 我对参数这块不熟悉请指点一下
create 执行存储过程报错出现符号_oracle存储过程编译错误:PLS-00103: 出现符号 "end-of-file"在需要下列之一时...
CREATEORREPLACEPROCEDUREUNFOLD_STANDBOM_FINAL_SEQ(CODEVARCHAR2,GROSS_TYPEVARCHAR2,--'N'表示使用净耗；'G'表示使用总耗COMPANYvarchar2)... 请高手帮忙解决下，我得瑟所有存储过程最后都是报这个错误。。。 展开
oracle导出6550,oracle imp 报错 6550 -高手.多谢了,
当前位置:我的异常网» Oracle技术»oracle imp 报错 6550 -高手.多谢了,oracle imp 报错 6550 -高手.多谢了,www.myexceptions.net网友分享于：2013-06-16浏览：613次oracle imp 报错 6550 --在线等高手.谢谢了,急啊...
mysql 存储过程 forall_PL/SQL 存储过程出错
createorreplaceprocedurep_index_checkisv_sqlvarchar2(2048);v_bttimestamp;v_fttimestamp;cursorc1isselect*fromindex_check_log;Beginforr1inc1loopv_sql:=r1.sql_statement;... 请Orale高手帮忙分析分析原因 展开
oracle 函数参数类型,关于function传入参数为数组（is table of）类型问题？？好像oracle不支持！...
具体如下：第一步：创建table数组类型TYPE t_person_id IS TABLE OF person.id%TYPE INDEX BY PLS_INTEGER;第二步：创建函数FUNCTION fn_get_id(person_id t_person_id,v_id person.id%TYPE)RETURN varchar2ISret_id...
Oracle

17,082

社区成员

55,236

社区内容

发帖
与我相关
我的任务
社区描述
Oracle开发相关技术讨论
社区管理员
  • 开发
  • Lucifer三思而后行
  • 卖水果的net
加入社区
  • 近7日
  • 近30日
  • 至今

加载中

查看更多榜单
社区公告
暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章