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语句没错,是否权限不足.
( 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语句没错,是否权限不足.