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
详细解决方案
PLS-00103:看不出来有关问题,高手帮看上
热度:172 发布时间:2016-04-24 07:14:51.0
相关解决方案
- PLS-00103: Encountered the symbol ";" when expecting
- FUNCTION SDMS_LY.MY_SPLIT 编译异常 异常:PLS-00103: 出现符号 "("在需要下列之一时: := . )
- pl/sql新手求教,函数创建出错,pls-00103,该如何处理
- PLS-00103 异常! 帮忙
- pl/sql生手求教,函数创建出错,pls-00103
- 编译过程失效提示“PLS-00103 encountered the symbol "OGMPZKFD"”解决方案
- oracle触发器 PLS-00103: 出现符号 "TABLE"在需要下列之一时:= .解决方法
- 创建job 报错 PLS-00103: 出现符号 "MI"在需要下列之一时:解决办法
- 存储过程报错,PLS-00103
- 大侠:PLS-00103: 出现符号 ""在需要下列之一时
- oracle创设存储过程 报错:pls-00103 : 出现符号 "create"
- oracle建立定时计划报错:ORA-06550第 七 行, 第 88 列: PLS-00103: 出现符号 "FMWW"在需要下列之一时
- PLS-00103:看不出来有关问题,高手帮看下
- PLS-00103:看不出来有关问题,高手帮看上
- Oracle 回到游标 PLS-00103: 出现符号 "CREATE"
- 如上代码,执行报错PLS-00103,请帮忙解决
- 诸位大神求教 PLS-00103
- 求急调试存储过程时,报ora-06550 PLS-00103
- 创建触发器出现PLS-00103: 异常
- 数据库存储方式出错!pts-00103,该怎么处理
- Error: PLS-00103: 出现符号 CREATE在需要下列之一时:
- ORA-06550 PLS-00103 报错记录