Oracle Text (MOSC)

MOSC Banner

After upgrade to 11.2.0.4 unable to delete rows from table with context index

edited Sep 24, 2013 12:08AM in Oracle Text (MOSC) 8 commentsAnswered ✓
 After upgrade the database to release 11.2.0.4 unable to commit a delete row. I see this error:
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'SYNCRN'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored


Platform Linux 86-64 . No trace files, No core file. No messages in alert.

Steps to reproduce the problem (production table and index is more complex , this is a simple example for reporduce the problem):

create table t_domain(id number,doc varchar2(100));
create index idx_domain on t_domain(doc) indextype is ctxsys.context;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center