create or replace procedure sp_selectstudents is begin select * from students; end sp_selectstudents;是非法的。 在 SQLPlus Worksheet里就提示“编译错误”。在pl/sql developer中可以正常生成存储过程。但是该存储过程是invalid的,根本不能运行。
在pl/sql developer一样会报变异错误阿SQL> create or replace procedure sp_selectstudents is 2 begin 3 select * from students; 4 end sp_selectstudents; 5 /Warning: Procedure created with compilation errors
在pl/sql developer一样会报变异错误阿SQL> create or replace procedure sp_selectstudents is 2 begin 3 select * from students; 4 end sp_selectstudents; 5 /Warning: Procedure created with compilation errors
在pl/sql developer一样会报变异错误阿SQL> create or replace procedure sp_selectstudents is 2 begin 3 select * from students; 4 end sp_selectstudents; 5 /Warning: Procedure created with compilation errors
begin
select * from students;
end sp_selectstudents;是非法的。 在 SQLPlus Worksheet里就提示“编译错误”。在pl/sql developer中可以正常生成存储过程。但是该存储过程是invalid的,根本不能运行。
2 begin
3 select * from students;
4 end sp_selectstudents;
5 /Warning: Procedure created with compilation errors
2 begin
3 select * from students;
4 end sp_selectstudents;
5 /Warning: Procedure created with compilation errors
2 begin
3 select * from students;
4 end sp_selectstudents;
5 /Warning: Procedure created with compilation errors
好象 SQL Window 不能编辑,很不方便。
=================================
File-->New-->Program Window-->procedure