oracle数据库存储过程实例(包含游标遍历的应用)
create or replacePROCEDURE "RAW_LOSEMONTH" ( dotime IN DATE) --输入参数AS ammeterIdx VARCHAR2(30);--定义变量BEGIN --定义游标 DECLARE CURSOR cursorbdz IS SELECT ammeterId FROM AMMETERINFO WHERE ammeterType='1'; BEGIN --for循环遍历游标 FOR c_temp IN cursorbdz LOOP ammeterIdx := c_temp.ammeterid; PROLOSEMONTH(ammeterIdx ,dotime);--调用另外一个存储过程 END LOOP; END;END RAW_LOSEMONTH;