我的oracle存储过程为什么执行不对？

Question

...
delete from system.aaa where name = str_name;
commit;
...

Answer 1

create or replace procedure sp_delete_aaa 
( str_name in number) as
BEGIN
 delete from bb where a = str_name;
END sp_delete_aaa;
/SQL> select * from bb;         A B
---------- -----------
         1 2003-1-22 1
         2 2003-1-23 1SQL> exec sp_delete_aaa(1);PL/SQL procedure successfully completedSQL> select * from bb;         A B
---------- -----------
         2 2003-1-23 1语句没错，是否权限不足.