SQL & PL/SQL

I get this error after I run my stored procedure.Surprisingly I expec this kind of error before one record could be inserted into any table in the DB.


In my stored procedure ,

a) I first insert a record in a table and then do a insert

select count(*) into l_count from emp;
--this record is inserted.
insert into employee values(lcount);
commit;


b) do more insert inside a loop

loop
--error happens inside the loop
insert into salary values ....

end loop


c) commit outside the loop


The error happens somewhere inside the loop.

Shouldnt I have got the error in the first insert itself ?

Thanks
m