LOB column - INSTEAD OF TRIGGER

Any work around on this issue!!!!!!

If a view with a LOB column has an INSTEAD OF TRIGGER, then you cannot specify a string INSERT/UPDATE into the LOB column. However, if this is a LONG column before the migration, then a string INSERT/UPDATE is allowed. So certain SQL statements which worked before will not work now. For example:

CREATE TABLE t(a LONG);
CREATE VIEW v AS SELECT * FROM t;
CREATE TRIGGER trig INSTEAD OF insert on v....;

INSERT INTO v VALUES ('abc')      -- works now
ALTER TABLE t MODIFY (a CLOB);
INSERT INTO v VALUES ('abc');     -- does not work now

The above statement throws an error because implicit conversion from character data to LOBs is not supported in instead-of triggers.

These restrictions may be removed in a future release. All other triggers work without a problem. Received on Tue Jan 29 2002 - 12:03:13 CET