sqf%rowcount 到底可以使用几次，如下边的格式，oracle 知道是哪个sql%rowcount 吗 请高手指点

[usernamezero]

APOINT NUMBER;
BPOINT NUMBER;
CPOINT NUMBER;
DPOINT NUMBER;
EPOINT NUMBER;
BEGIN
INSERT INTO SB_LOG SELECT AC.*,'0' FROM SLOFSI.AC29@SHEBAO AC;
--APOINT:=SQL%ROWCOUNT;
SAVEPOINT P1;
DELETE SLOFSI.AC29@SHEBAO;
--BPOINT:=SQL%ROWCOUNT;
SAVEPOINT P2;

[DragonBill]

SQL%ROWCOUNT 返回值是你的SQL语句所影响的记录行数

[zcs_1]

上面的APOINT是插入到SB_LOG的记录数， BPOINT是删除的记录数，SQL%ROWCOUNT记录的是最近的一个DML操作数据的记录数，一试便知，可以这样

BEGIN

APOINT NUMBER;
BPOINT NUMBER;
CPOINT NUMBER;
DPOINT NUMBER;
EPOINT NUMBER;
BEGIN
INSERT INTO SB_LOG SELECT AC.*,'0' FROM SLOFSI.AC29@SHEBAO AC;
APOINT:=SQL%ROWCOUNT;

DBMS_OUTPUT.PUT_LINE(apoint);

SAVEPOINT P1;
DELETE FROM SLOFSI.AC29@SHEBAO;
BPOINT:=SQL%ROWCOUNT;

DBMS_OUTPUT.PUT_LINE(bpoint);

SAVEPOINT P2;

END;
/