Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Problems with LOBs and triggers
Hi!
I'm getting a strange error message here. Seems like you are not allowed to update LOB values in a trigger.
problem cause: Triggers not allowed to update LOBs problem symptom: changes made to tables containing LOBs are rejected, and Oracle returns the following error: "ORA-22275 invalid LOB locator specified"
The documentation simply tells you to get rid of the trigger. But there must be a way to manipulate LOB values in a trigger.
Any idea?
This is 8.1.6 on Win2k.
Thanks, Received on Mon Nov 06 2000 - 18:09:19 CST
![]() |
![]() |