执行一个存储过程后,执行时没错误提示,但是数据库的表中就是没数据是怎么回事啊?请教高手
执行一个存储过程后,执行时没错误提示,但是数据库的表中就是没数据是怎么回事啊?请教高手,代码如下create or replace procedure inster_delete_student --(Sno in varchar2,Sname in varchar2,Ssex in varchar2,Sage in number,Sdept in varchar2)
as
begin
--declare i number(8):=1;
for i in 1..5 loop
insert into student_info_1 (Sno,Sname,Ssex,Sage,Sdept) values ('01','张三','女',18,'外语系');
insert into student_info_1 (Sno,Sname,Ssex,Sage,Sdept) values ('05','王丽','女',21,'文学系');
insert into student_info_1 (Sno,Sname,Ssex,Sage,Sdept) values ('08','钱多多','女',21,'计算机系');
end loop;
commit;
end inster_delete_student;