This discussion is archived
10 Replies Latest reply: Dec 26, 2012 5:34 AM by EdStevens RSS

Unable to insert a record in any table

968361 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points