10 Replies Latest reply: Dec 26, 2012 7:34 AM by EdStevens RSS

    Unable to insert a record in any table

    968361
      Hi,

      I was working on a procedure in which i had to insert 1,00,000 records each in 3 tables. But the procedure stopped after inserting 56000 records.
      After that I again ran the query but now it is not inserting a single record.

      I just created a dummy table

      create table vinod1(no number);

      and tried to insert a value in it using

      insert into vinod1 values(100);

      But to my surpries the query has been executing since last 10 and has not inserted a row.

      I tried it on SQLPLUS also and i am using oracle 10g


      Can you please help me and explain why i am not able to insert even though I am able to create table.


      Thanks
      -Vinod