Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

commit not commiting data

455790Aug 14 2006 — edited Aug 14 2006

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.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 11 2006
Added on Aug 14 2006
20 comments
728 views