DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: ORA-22920 row containing the LOB value is not locked

  1. #1
    Join Date
    Mar 2001
    Location
    Reading, U.K
    Posts
    598
    hi
    "ORA-22920 row containing the LOB value is not locked"
    how to solve this error?

    i am fetching a blob value from a table using a java file
    Cheers!
    OraKid.

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Are you trying to perform an update on that row. On such case you would have to use SELECT... FOR UPDATE and lock that row before you perform any update.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


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