如果在客户端执行,要commit才行,
exec aa_ta(1,'abc');
commit;
SQL> select * from czta; ID COLA COLB COLAA
---------- ---------- ---------- ----------
1 aa1 b1 aa1
exec aa_ta(1,'abc');
commit;
SQL> select * from czta; ID COLA COLB COLAA
---------- ---------- ---------- ----------
1 aa1 b1 aa1
aa_ta(1,''abc'); ??????
end;
commit; --加上commit;
as
begin
update czta set cola=colaa where id=ida;
commit;
end aa_ta;
----------
89create or replace procedure aa_ta(ida in number,colaa in number)
as
begin
update z set a=colaa where a=ida;
commit;
end aa_ta;
/
Procedure createdSQL> execute aa_ta(89,12);PL/SQL procedure successfully completedSQL> select a from z; A
----------
12