create or replace procedure CheckUserMdn(p_iMDN in varchar2,p_iBusinessID in integer,p_oResult out integer) is CURSOR c_CheckUser IS SELECT tMDNSegment.SegmentID FROM tMDNSegment,tProvince WHERE tMDNSegment.ChargeProperty=0 AND tMDNSegment.SegmentCode=substr(p_iMDN,7) .....; begin for v_sor in c_CheckUser loop if ... then return; end if; end loop; end CheckUserMdn;
可以
还有,在ORACLE过程中,开始事务与提交事务的语句是什么?
只要设置正确,每个session在没有commit之前都在一个事务中,rollback回滚事务
is
CURSOR c_CheckUser IS
SELECT tMDNSegment.SegmentID FROM tMDNSegment,tProvince
WHERE tMDNSegment.ChargeProperty=0 AND tMDNSegment.SegmentCode=substr(p_iMDN,7)
.....;
begin
for v_sor in c_CheckUser loop
if ... then
return;
end if;
end loop;
end CheckUserMdn;