DECLARE discount NUMERIC;
DECLARE price NUMERIC;
DECLARE temp NUMERIC;
DECLARE percent NUMERIC;
DECLARE my_cursor refcursor;
DECLARE pay_out NUMERIC;
BEGIN
temp = 0;
OPEN my_cursor FOR SELECT pricing.prc_price_component.price
FROM pricing.prc_price_component
INNER JOIN
(SELECT pricing.prc_agreement_item.agreement_item_id FROM pricing.prc_agreement_item WHERE
pricing.prc_agreement_item.agreement_id = $1 AND
pricing.prc_agreement_item.role_type_id = 'SALES_REP')
_sr_agreement_item_ ON _sr_agreement_item_.agreement_item_id =
pricing.prc_price_component.agreement_item_id;
LOOP
FETCH my_cursor into price;
IF(discount>=price AND price>=temp) THEN
temp = price;
pay_out = percent;
END IF;
END LOOP;
return pay_out;
CLOSE my_cursor;
END;在FETCH记录集的时候提示MISS"IN/FROM" at the end of the statement at line 19 near ";"就是 FETCH my_cursor into price;这个写的有问题吗?请高手帮忙看看,谢谢
DECLARE price NUMERIC;
DECLARE temp NUMERIC;
DECLARE percent NUMERIC;
DECLARE my_cursor refcursor;
DECLARE pay_out NUMERIC;
BEGIN
temp = 0;
OPEN my_cursor FOR SELECT pricing.prc_price_component.price
FROM pricing.prc_price_component
INNER JOIN
(SELECT pricing.prc_agreement_item.agreement_item_id FROM pricing.prc_agreement_item WHERE
pricing.prc_agreement_item.agreement_id = $1 AND
pricing.prc_agreement_item.role_type_id = 'SALES_REP')
_sr_agreement_item_ ON _sr_agreement_item_.agreement_item_id =
pricing.prc_price_component.agreement_item_id;
LOOP
FETCH my_cursor into price;
IF(discount>=price AND price>=temp) THEN
temp = price;
pay_out = percent;
END IF;
END LOOP;
return pay_out;
CLOSE my_cursor;
END;在FETCH记录集的时候提示MISS"IN/FROM" at the end of the statement at line 19 near ";"就是 FETCH my_cursor into price;这个写的有问题吗?请高手帮忙看看,谢谢
解决方案 »
- 产品表属性分两个数据表存储的问题
- INNODB最好用varchar,这个可以理解,但是为什么MYISAM建议用定长的数据列?
- N多人都没搞定的SQL语句
- MySQL默认字符集的问题
- 高分求深入学习 mysql 的视频,不要基础的!!!
- 跪求,大虾....为什么在mysql>命令行输不了汉字,我电脑DOC命令行也输不了汉字
- Sqlyog连接Mysql时错误:2004,can't create tcp/ip sokect (10050).请问怎么解决?
- 取得自增主键值的并发性问题
- 有关pgaccess的问题,大家帮个忙
- 把.dbf文件转化成为mysql的数据库表的文件的软件在哪找啊?
- mysql6的问题
- mysql 安装问题
declare myrec record;for myrec in select .... loop....
end loop
declare myrec record; for myrec in select .... loop ....
end loop