Problems with LOBs and triggers

From: Helmut Daiminger <hdaiminger_at_vivonet.com>
Date: Mon, 6 Nov 2000 16:09:19 -0800
Message-Id: <10672.121262@fatcity.com>

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