|Re: Multi Column Datastore (spit from hijacked old thread) [message #572197]
||Fri, 07 December 2012 04:56
Registered: November 2011
EDIT: I know it's an old thread, but it applies to my problem. Note that I am using Oracle 11g XE.|
EDIT 2: nevermind, I forgot to put SYNC (ON COMMIT) in PARAMETERS.
Hello, I have a problem with the code you have given:
create or replace trigger t_trg
before update of column2, column3 on t
for each row
:new.column1 := :new.column1;
One or more of my columns in the column list is a LOB and it gives me the following error:
ORA-25006: cannot specify this column in UPDATE OF clause
25006. 00000 - "cannot specify this column in UPDATE OF clause"
*Cause: Attempt to create a trigger on update of a column whose
datatype is disallowed in the clause, such as LOB and
*Action: Remove the UPDATE OF clause.
But if I remove the mentioned clause, even though it compiles, the search doesn't work on newly inserted rows.
[mod-edit EDIT 3: split from hijacked old thread http://www.orafaq.com/forum/t/41972/43710/ by bb]
[Updated on: Tue, 22 January 2013 01:55] by Moderator
Report message to a moderator