Home » SQL & PL/SQL » SQL & PL/SQL » strange behaviour when updating
strange behaviour when updating [message #282720] Fri, 23 November 2007 03:02 Go to next message
subusona
Messages: 70
Registered: March 2005
Location: delhi
Member
at development database I have a table say 'xyz' having column name as "processed_flag". There are no triggers against this table. when i update a column processed_flag from 'Y' to 'N' and then commit I find the flag again changes to 'Y'. Strange enough I could not able to find why this is behaving like this. Any answer?? There are no triggers on the table.
Re: strange behaviour when updating [message #282726 is a reply to message #282720] Fri, 23 November 2007 03:13 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you say there is no trigger.
Now post the evidences.

Post (copy and paste) what you do to see all what you said.
Are you sure anyone else reverse your operation?

Regards
Michel

[edit: typo]

[Updated on: Fri, 23 November 2007 03:39]

Report message to a moderator

Re: strange behaviour when updating [message #282729 is a reply to message #282726] Fri, 23 November 2007 03:30 Go to previous messageGo to next message
subusona
Messages: 70
Registered: March 2005
Location: delhi
Member
SQL> select rdr_id,account_id,processed_flag_yn from XYZ where rdr_id = 455;

RDR_ID ACCOUNT_ID P
---------- ---------- -
455 714175 Y

SQL> update XYZ set processed_flag_yn = 'N' where rdr_id = 455;

1 row updated.

SQL> select rdr_id,account_id,processed_flag_yn from XYZ where rdr_id = 455;

RDR_ID ACCOUNT_ID P
---------- ---------- -
455 714175 N

SQL> commit;

Commit complete.

SQL> /

Commit complete.

SQL> select rdr_id,account_id,processed_flag_yn from XYZ where rdr_id = 455;

RDR_ID ACCOUNT_ID P
---------- ---------- -
455 714175 Y
Re: strange behaviour when updating [message #282731 is a reply to message #282729] Fri, 23 November 2007 03:40 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I don't see there is no trigger.
And no more your Oracle version (at least 3 decimals).

Regards
Michel
Re: strange behaviour when updating [message #282736 is a reply to message #282720] Fri, 23 November 2007 04:20 Go to previous messageGo to next message
kir_ait
Messages: 198
Registered: November 2007
Location: Bangalore,India
Senior Member

SQL> select rdr_id,account_id,processed_flag_yn from XYZ where rdr_id = 455;

RDR_ID ACCOUNT_ID P
---------- ---------- -
455 714175 N


It shows the field had been changed. When you do commit, it changes to Y. Something wrong there!?

Kiran
Re: strange behaviour when updating [message #282742 is a reply to message #282736] Fri, 23 November 2007 04:43 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Most probably, either another process changed the same record or a system-trigger that fires on commit reverted your change.
Re: strange behaviour when updating [message #282755 is a reply to message #282720] Fri, 23 November 2007 05:54 Go to previous messageGo to next message
shahriar_g
Messages: 1
Registered: September 2007
Location: Bangladesh
Junior Member
Try to execute this operation using dba priviledge.Because I think sever is configured like [trigger of course]... If a group of user with certain previledges make some changes then it is rolled back.
Re: strange behaviour when updating [message #282769 is a reply to message #282755] Fri, 23 November 2007 06:48 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
First it is time to search for triggers and their code.
Then we will think what action to do.

Regards
Michel
Re: strange behaviour when updating [message #282790 is a reply to message #282720] Fri, 23 November 2007 08:01 Go to previous messageGo to next message
rajavu1
Messages: 1574
Registered: May 2005
Location: Bangalore , India
Senior Member

I agree with Frank.

Some backgroud operation might have triigered by changing the status. And the same/different process might have changed the status again after that.

Thumbs Up
Rajuvan.
Re: strange behaviour when updating [message #282792 is a reply to message #282790] Fri, 23 November 2007 08:06 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
[Off topic]
Do you and kir.ait not able to talk directly at your place?

Regards
Michel
Re: strange behaviour when updating [message #282795 is a reply to message #282720] Fri, 23 November 2007 08:13 Go to previous message
rajavu1
Messages: 1574
Registered: May 2005
Location: Bangalore , India
Senior Member


Cool

Michel..

Your are a genius !!!!!!!!!!!!!!!!!!!!

Any objections from anybody ???

Thumbs Up
Rajuvan
Previous Topic: Create several procedures
Next Topic: UPPER CASE update
Goto Forum:
  


Current Time: Sun Dec 04 08:45:39 CST 2016

Total time taken to generate the page: 0.10235 seconds