row is not inserting into table

Question

The table is present in oracle database, I am updating that table with one record. It's executing and when I type select * from that table it's showing that record.

But the problem is when I commit the changes. The table is showing nothing - I am not seeing anythng inside table, it's showing 0 records.

Can you please help me?

insert into recon values(1,'sri',-1,'20090806');

after this if i write

select * from recon;

It's showing that record but after commit it's showing nothing. There is no trigger for that table.

its not a view.

Check if there is a trigger on the table - also, please post a log of your SQL commands to help us analyze the problem. — dpbradley
– dpbradley, Commented Aug 6, 2009 at 13:12
insert into recon values(1,'sri',-1,'20090806'); after this if i write select * from recon; its showing that record but after commit its showing nothing. there is no trigger for that table — musicking123
– musicking123, Commented Aug 6, 2009 at 13:29
so just to be sure, please do this in the same session: insert into recon values(1,'sri',-1,'20090806'); commit; select * from recon; — dpbradley
– dpbradley, Commented Aug 6, 2009 at 13:33
well, that's good - eliminates IDE side effects. Taking your results at face value, the only thing I can think of would be to enable auditing on the table to see if there is another process somewhere that is deleting the row after you insert it. Do you have the necessary privileges to do that? — dpbradley
– dpbradley, Commented Aug 6, 2009 at 14:37

Theo · Accepted Answer · 2009-08-06 14:43:04Z

3

It's a global temporary table, after commiting it is emptied.

There are two kind of temp tables, 1 after commit emptied, 2.after ending session emptied.

answered Aug 6, 2009 at 14:43

Theo

8194 silver badges6 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Dave Costa Over a year ago

Definitely a possibility. To verify, SELECT temporary FROM user_tables WHERE table_name = 'recon'. If this is 'Y' then it is a global temporary table. I'm not sure how to verify whether it is set to delete on commit, but it would certainly explain the behavior you are seeing.

Theo Over a year ago

where table_name = 'recon' -> where table_name = 'RECON'

dpbradley Over a year ago

@musicking123 - did it turn out that this was a temp table?

kristof · Accepted Answer · 2009-08-06 13:40:33Z

0

My guess would be that the transaction was not committed properly, initially I thought that it was because of nested transactions (I work in SQLServer) but could be basically because of not properly committed transaction

edited Aug 6, 2009 at 13:40

answered Aug 6, 2009 at 13:18

kristof

54k24 gold badges89 silver badges111 bronze badges

1 Comment

musicking123 Over a year ago

am commiting it afre inserting.

81967 · Accepted Answer · 2009-08-06 13:45:52Z

0

If you are the admin, Check if other users are logged into the the database and are using that table, unlock the user from that table/database.

answered Aug 6, 2009 at 13:45

81967

1152 silver badges9 bronze badges

2 Comments

musicking123 Over a year ago

how to check if other users are accessing tha same database/table?

81967 Over a year ago

Check out this link shutdownabort.com/dbaqueries/…

Collectives™ on Stack Overflow

row is not inserting into table

3 Answers 3

3 Comments

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related