To modify a LOB,
SELECT id, blob FROM test FOR UPDATE
Note that you must use "FOR UPDATE" in the select statement or you will receive "ORA-22920: row containing the LOB value is not locked" when writing to the LOB.
The above lines are taken from the below link :
How to use Oracle LOBS/BLOBS/CLOBS
No comments:
Post a Comment