| strange behaviour when updating [message #282720] |
Fri, 23 November 2007 03:02  |
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 #282729 is a reply to message #282726] |
Fri, 23 November 2007 03:30  |
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 #282736 is a reply to message #282720] |
Fri, 23 November 2007 04:20 |
|
|
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 #282755 is a reply to message #282720] |
Fri, 23 November 2007 05:54 |
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.
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
