Oracle Text. Try to update column with context ind

2019-06-04 21:24发布

问题:

I'm trying to update a column with a context index.

CREATE TABLE new_table(first_column NUMBER, text CLOB);
INSERT INTO new_table VALUES(1,'Oracle');
INSERT INTO new_table VALUES(2,'Text');
COMMIT;
CREATE INDEX idx_new_table_text ON new_table(text) INDEXTYPE IS CTXSYS.CONTEXT PARAMETERS ('SYNC ( ON COMMIT)');

With "PARAMETERS ('SYNC ( ON COMMIT)')" parameter I was able to add data to the table. But I still can't update the data in this column or delete rows from this table.

UPDATE new_table SET text = 'new text' WHERE first_column = 3;
COMMIT;

Аnd after committing, I see errors: "Commit failed" AND "ORA-00604: error occurred at recursive SQL level 1 ORA-06550: String 1, column 7: PLS-00306: wrong number or types of agruments in call to 'SYNCRN'" Tell me, please, what should I do to make UPDATE and DELETE start working?