why only 1 of the 2 tables that i specified to the insertion of the data?

[Deanna Tran_1]

this is the script that I use?



create PROCEDURE tester1 IS
numcount number:=0;
begin
while true loop
numcount:=numcount+1;
insert into employee1 values (numcount,'lkjljf','dlkjdeann',87970.80);
insert into employee value (numcount, 'dkjl','dlakdjfelsdjfe',10000,90);
update employee1 set salary = salary + 900
where empid = numcount;
update employee set salary = salary + 10000
where empid = numcount;
update employee set salary = salary + 5000
where empid = numcount;
update employee set lastname = 'dkvnlkdoije'
where empid = numcount;
commit;
end loop;
END;
/

[A. Clay Stephenson · Accepted solution]

insert into employee1 values (numcount,'lkjljf','dlkjdeann',87970.80);
insert into employee value (numcount, 'dkjl','dlakdjfelsdjfe',10000,90);

If I assume that tables employee and employee1 have the same schema, you are passing 4 arguments into one and 5 into the other. Also,
you uses VALUE rather than VALUES in one statement.

[Deanna Tran_1]

thanks...I have make those changes...but still was unsuccesful?

[A. Clay Stephenson]

Without seeing your error conditions, I have no idea. You are aware that you have an endless loop? You should probably have something like while numcount <= 100.

[Deanna Tran_1]

hi..thanks...i am aware that i infinite loop...and I did figure it out what was the errors...it was the typo...and now it works fine...thanks again...for helping me