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?