create or replace procedure BY_STOCK_IN_ADJUST_ACTION(
requestids in integer,
ids out integer,
modedatacreater out varchar2,
thecursor IN OUT cursor_define.weavercursor)
as
inum integer;
tanum integer;
gpCode varchar2(255); -- 股票代碼
poolLevel integer;--股票級別
target varchar2(255);--目標產品
begin
-- 根據requestid 查找對應流程所需資料，股票調整流程
select a.tiaokcpmc ,a.gupjb,substr(b.jiargpdm,0,length(b.jiargpdm)-2) into target,poolLevel,gpCode from formtable_main_144 a,formtable_main_144_dt1 b where a.id=b.mainid and a.requestid=requestids;
select count(1) into inum from uf_stock_pool where stockcode = gpCode and fundcode=target and pool_id=poolLevel;
if inum =0 then
return;
end if;
--判斷是否pool_id
if tanum > 0 then --pool_id 全部為1
--其中的問題就是，update陳述句有多條，怎么將多條資料中 id,modedatacreater 放到thecursor游標中
update(select * from uf_stock_pool a where stockcode=gpCode and fundcode=target ) set fundcode=target ,pool_id=0;
else --pool_id 全部為0；
update(select * from uf_stock_pool a where stockcode=gpCode and fundcode=target) set fundcode= target,pool_id=1;
end if;
<<success_msg>>
open thecursor for
select ids,modedatacreater from dual;
when others then
rollback;
end;
uj5u.com熱心網友回復：
這個存盤沒有完整，希望大佬補充一下；
uj5u.com熱心網友回復：
RETURNING 欄位 BULK COLLECT INTO enums，放在update陳述句的后面uj5u.com熱心網友回復：
什么意思啊·uj5u.com熱心網友回復：
uj5u.com熱心網友回復：
你的ids和creater 是變數嗎？
你前面要定義一個PLSQL表，兩列的。然后into進去，游標的情況，我沒試過，你可以試試
uj5u.com熱心網友回復：
create or replace procedure BY_STOCK_IN_ADJUST_ACTION( requestids in varchar2,
ids out integer,
creater out varchar2,
thecursor IN OUT cursor_define.weavercursor)
as
inum integer;
tanum integer;
gpCode varchar2(255); -- 股票代碼
poolLevel integer;--股票級別
target varchar2(255);--目標產品
TYPE CIDS IS TABLE OF integer;
ci CIDS;
TYPE MCR IS TABLE OF integer;
cr MCR;
begin
-- 根據requestid 查找對應流程所需資料，股票調整流程
select a.tiaokcpmc ,a.gupjb,substr(b.jiargpdm,0,length(b.jiargpdm)-2) into target,poolLevel,gpCode from formtable_main_144 a,formtable_main_144_dt1 b where a.id=b.mainid and a.requestid=requestids;
select count(1) into inum from uf_stock_pool where stockcode = gpCode and fundcode=target and pool_id=poolLevel;
if inum =0 then
return;
end if;
--判斷是否pool_id
select (case when instr(a,'1') >0 then 1 else 0 end) into tanum from (select wm_concat(pool_id) a from uf_stock_pool where stockcode=gpCode and fundcode=target );
if tanum > 0 then --pool_id 全部為1
update(select * from uf_stock_pool a where stockcode=gpCode and fundcode=target ) set fundcode=target ,pool_id=0;
else --pool_id 全部為0；
update(select * from uf_stock_pool a where stockcode=gpCode and fundcode=target) set fundcode= target,pool_id=1
RETURNING id,modedatacreater BULK COLLECT INTO ci,cr;
end if;
commit;
open thecursor for
select ids,creater from dual;
Exception
when others then
rollback;
end;
怎么將ci，cr放到thecursor游標中
uj5u.com熱心網友回復：
這個好像不能再放到 游標里面了。里面的內容只能遍歷的方式 查詢。
uj5u.com熱心網友回復：
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/63530.html
標籤：高級技術
上一篇：AIcc2019條形碼插件