Home » Server Options » Text & interMedia » Re: Multi Column Datastore (spit from hijacked old thread)
Re: Multi Column Datastore (spit from hijacked old thread) [message #572197] Fri, 07 December 2012 04:56
Messages: 62
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:
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

Previous Topic: PDF Document search & Indexing NOT WORKING
Next Topic: Oracle Text index CTXCAT not working with leading wild card
Goto Forum:

Current Time: Fri Mar 24 01:26:57 CDT 2017

Total time taken to generate the page: 0.13016 seconds