Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

after insert commit completed but I cannot see data.

Printaporn_1
Esteemed Contributor

after insert commit completed but I cannot see data.

I use following insert statement:
Insert Into
failure(SN,FailDate,FailCode,Ulocation,PN,Station,Test,SymptomCode,Series,TTF,Te
mp,Volt,FREQ,ERROR_Msg,FailComment,Source,Fixed,Rep_Date,So)
values('CAT0711023Y',sysdate ,'613','Q5','','1350','','',1
,'1','0','0','0','368','','','R',sysDate ,'')
but after select I found no data
SQL> Insert Into
failure(SN,FailDate,FailCode,Ulocation,PN,Station,Test,SymptomC
ode,Series,TTF,Temp,Volt,FREQ,ERROR_Msg,FailComment,Source,Fixed,Rep_Date,So)
va
lues('CAT0711023Y',sysdate ,'613','Q5','','1350','','',1
,'1','0','0','0','368',
'','','R',sysDate ,'');
1 row created.
SQL> commit;
Commit complete.
SQL> select sn from failure where sn = 'CAT0711023Y';
no rows selected
(some of insert was truncate here )
---------------------
I try troubleshooting what I found is:
1. rebuild all indexes , analyze table compute statistics , nothing corrupted.
2. if remove insert column "fixed" it will be able to insert.
( I mean after commit complete I can see data for those sn).
3. rename table failure to failure_a it will be able to insert.
4. if rename failure_a back to failure again it will not be able to see data
after insert.
5. no constraint related to failure table.
6. test with other sn got same result as above.
---------------------
I test this same query with another instance with same structure in this same
machine , it work fine.
--------------------
What wrong with my failure table.
thanks in advance,
enjoy any little thing in my life
9 REPLIES
Wodisch
Honored Contributor

Re: after insert commit completed but I cannot see data.

Hi,

do you have any "stored procedure" working upon "insert", and hence *doing* something with/to your data row?

FWIW,
Wodisch
Printaporn_1
Esteemed Contributor

Re: after insert commit completed but I cannot see data.

Hi Wodisch,
thanks for fast response but
I have no store procedure.
enjoy any little thing in my life
Yogeeraj_1
Honored Contributor

Re: after insert commit completed but I cannot see data.

hello,

could be a trigger.

select object_name, object_type
from user_objects;

this will show you all objects own by the owner of the objects.

post the output.

Other troubleshooting options will be to use SQLTRACE and TKPROF.

Regards
Yogeeraj

No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Steven E. Protter
Exalted Contributor

Re: after insert commit completed but I cannot see data.

How about rollback segments? Is the database busy, could there be competition wiith other users.

metalink did provide a dozen hits none of which meant anything to me.

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Printaporn_1
Esteemed Contributor

Re: after insert commit completed but I cannot see data.

Thanks Yogeeraj abd Steven.
I still doesn't get any clue from trigger/user_objects or rollback.
I just have simple structure database. no resource contention.
I cannot found similar problem in metalink.
Anyway I open a TAR but no response from Oracle for 48 Hrs.
I will update again if problem can be resolved.
enjoy any little thing in my life
Yogeeraj_1
Honored Contributor

Re: after insert commit completed but I cannot see data.

hi,

try the SQLTRACE option.

trace your sessions and you will get the solution.

if you need further help, let us know.

best regards
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Printaporn_1
Esteemed Contributor

Re: after insert commit completed but I cannot see data.

 
enjoy any little thing in my life
Printaporn_1
Esteemed Contributor

Re: after insert commit completed but I cannot see data.

Ohhhhh ! I just realize that I post all my screen capture.
WHo know how can I delete my previous post ! it expost my password !!!
SO Stupid I am.
enjoy any little thing in my life
Printaporn_1
Esteemed Contributor

Re: after insert commit completed but I cannot see data.

Hi,
Thanks for help now my problem is solved by re-start database.

same insert statement work !
-----------

SQL> Insert Into failure(SN,FailDate,FailCode,Ulocation,PN,Station,Test,SymptomC
ode,Series,TTF,Temp,Volt,FREQ,ERROR_Msg,FailComment,Source,Fixed,Rep_Date,So) va
lues('CAT0711023Y',sysdate ,'613','Q5','','1350','','',1 ,'1','0','0','0','368',
'','','R',sysdate ,'');

1 row created.

SQL> commit
2 ;

Commit complete.

SQL> select sn from failure where sn = 'CAT0711023Y';

SN
-------------------------
CAT0711023Y

------------------
This is strange , will see what Oracle will response.
But now my big problem is I post my db password ;-(
enjoy any little thing in my life