I have a procedure which is very simple the first part of the proc, selects data from a table and inserts it into another table.
so something like
begin
insert into table1(col1,col2,col3,col4)
select val1,val2,val3,val4,val5 from table2
commit;
-- Enter a single row....
insert into table1(col1,col2,col3,col4)
select val1,val2,val3,val4 from table2
commit;
end
Now the problem is that once it gets to the second insert , i am expecting it to insert that single row at the bottom of the table, but it gets stuck in row 3, so i am thinking that the insert above which is doing multiple lines has not finished.
Is there some sort of buffering on the inserts which i need to turn off.