Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> LOB column - INSTEAD OF TRIGGER
Hi
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 - 05:03:13 CST