Update not working on particular column
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: Update not working on particular column

  1. #1
    Join Date
    Aug 2000
    Posts
    132
    Never seen this one before - we perform an update on prod_desc, feedback tells us row was updated, we commit the changes we select the column - change did not take effect. The same user can update other columns on the table with no problems. What am I missing?

  2. #2
    Join Date
    Jul 2000
    Posts
    296
    Maybe a trigger, or another user also updating the same row, directly after the commit.

  3. #3
    Join Date
    Aug 2000
    Posts
    132
    hmm..we do have a trigger that automatically updates our interMedia index but I'm not sure why that would prevent changes from showing up. What I really don't understand is why it thinks it updated the row?

  4. #4
    Join Date
    Oct 2000
    Posts
    123
    To my experience, sometimes you just don't know what the rows or coumns be updated are the ones you really want.

    Thanks

  5. #5
    Join Date
    Dec 2000
    Posts
    75
    Use session audit or log miner to figure out what happened.
    goodhealth

  6. #6
    Join Date
    Dec 2000
    Posts
    87
    sukimac,

    I'm having the same problem with same situation (I also have an update trigger), would you please tell me your solution to it if you've already done it. Thanks.


  7. #7
    Join Date
    Feb 2001
    Posts
    125
    Hi,

    Pl. Check your trigger if there is any exception block
    if DBMS_OUTPUT.PUT_LINE is used in exception block
    then change it with RAISE_APPLICATION_ERROR.

    check your trigger "on update of <column_name> " is correct.



    P. Soni

  8. #8
    Join Date
    Jul 2000
    Posts
    243
    Hi sukimac
    use the returning command to get the values you tryed to update after the update. it works like this

    update table_name
    set column_name = X
    returning column_name [into v_x];

    dbms_output.put_line(v_x);

    this works only if you update one row at a time! if not, it will not work!!!

    you can also use sql%rowcount to count how many lines you updated

    if you have more problems, show us a print out of the trigger

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width