Simpler Navigation for Servers and Operating Systems
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

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

SOLVED
Go to solution
Deanna Tran_1
Frequent Advisor

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

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;
/
4 REPLIES
A. Clay Stephenson
Acclaimed Contributor
Solution

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

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.

If it ain't broke, I can fix that.
Deanna Tran_1
Frequent Advisor

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

thanks...I have make those changes...but still was unsuccesful?
A. Clay Stephenson
Acclaimed Contributor

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

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.

If it ain't broke, I can fix that.
Deanna Tran_1
Frequent Advisor

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

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