Oracle中添加存储过程,警告:程序创建的编译错误
SQL> create or replace procedure update_test
2 as
3 begin
4 update test set Name = '10'
5 commit;
6 end update_test;
7
8
9
10 /
Warning: Procedure created with compilation errors
SQL>就问是怎么一回啦?
SQL> create or replace procedure update_test
2 as
3 begin
4 update test set Name = '10'
5 commit;
6 end update_test;
7
8
9
10 /
Warning: Procedure created with compilation errors
SQL>就问是怎么一回啦?
update test set Name = '10';
create or replace procedure update_test
as
begin
update test set Name = '10';
commit;
end update_test;/
这样编译是不会有错误的,除非表test 不存在,或者name字段名有误。