Re: Multi Column Datastore (spit from hijacked old thread) [message #572197] |
Fri, 07 December 2012 04:56 |
|
fabi88
Messages: 112 Registered: November 2011
|
Senior Member |
|
|
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
begin
:new.column1 := :new.column1;
end;
One or more of my columns in the column list is a LOB and it gives me the following error:
Quote:Error report:
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
nested table.
*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
|
|
|