请问java高手,spring如何解析oracle返回的数据包,当记录集嵌套记录集时,如何解析呢?感激不尽
以下存储过程,返回的记录集的字段又包含记录集,resultlist的属性Property是个记录集,在这种情况下如何解析所有信息呢?typePropertyListist...
以下存储过程,返回的记录集的字段又包含记录集,resultlist的属性Property是个记录集,在这种情况下如何解析所有信息呢?
type PropertyList is table of Property index by binary_integer;---PropertyList对象
FUNCTION FUNC_Wechat_ClaimSearchList(i_ClientName in varchar2,
i_CardNo in varchar2,
i_LicenseNo in varchar2)
return SearchClmList IS
Propertys PropertyList;----对象,放在list的一个列中
resultlist SearchClmList;
loopcount NUMBER := 1;
vCaseStatus VARCHAR2(10);
BEGIN
loopcount := 1;
FOR cf IN (select
c.caseno --事故号
from c_claim c, p_public_policy cpp, c_property cp
where cpp.insurantname = trim(i_ClientName)
and c.ismain = '1'
order by c.notifydate desc) LOOP
--list中的子对象--
SELECT ce.ifobject,
ca.ifauditpass,
sum(ce.lossamount) lossamount BULK COLLECT
INTO Propertys
FROM c_estimatelist ce, c_lossitem cm, c_estimate ca
WHERE ca.caseno = cf.caseno
AND ce.estimateno = ca.estimateno
GROUP BY ce.ifobject, ca.ifauditpass, cm.memo;
----赋值list-----------
resultlist(loopcount).ClaimNo := cf.caseno;
resultlist(loopcount).Property := Propertys;----赋值对象
loopcount := loopcount + 1;
IF loopcount > 19 THEN
EXIT;
END IF;
END LOOP;
RETURN resultlist;
END FUNC_Wechat_ClaimSearchList;
请问,spring如何对象resultlist的Property属性的所有信息呢? 展开
type PropertyList is table of Property index by binary_integer;---PropertyList对象
FUNCTION FUNC_Wechat_ClaimSearchList(i_ClientName in varchar2,
i_CardNo in varchar2,
i_LicenseNo in varchar2)
return SearchClmList IS
Propertys PropertyList;----对象,放在list的一个列中
resultlist SearchClmList;
loopcount NUMBER := 1;
vCaseStatus VARCHAR2(10);
BEGIN
loopcount := 1;
FOR cf IN (select
c.caseno --事故号
from c_claim c, p_public_policy cpp, c_property cp
where cpp.insurantname = trim(i_ClientName)
and c.ismain = '1'
order by c.notifydate desc) LOOP
--list中的子对象--
SELECT ce.ifobject,
ca.ifauditpass,
sum(ce.lossamount) lossamount BULK COLLECT
INTO Propertys
FROM c_estimatelist ce, c_lossitem cm, c_estimate ca
WHERE ca.caseno = cf.caseno
AND ce.estimateno = ca.estimateno
GROUP BY ce.ifobject, ca.ifauditpass, cm.memo;
----赋值list-----------
resultlist(loopcount).ClaimNo := cf.caseno;
resultlist(loopcount).Property := Propertys;----赋值对象
loopcount := loopcount + 1;
IF loopcount > 19 THEN
EXIT;
END IF;
END LOOP;
RETURN resultlist;
END FUNC_Wechat_ClaimSearchList;
请问,spring如何对象resultlist的Property属性的所有信息呢? 展开
1个回答
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询