PLS-00306: Wrong Number Or Types Of Arguments In Call To 'SYNCRN' Error When Searching In WebCenter Content (Doc ID 1596005.1)

Last updated on MAY 03, 2023

Applies to:

Symptoms

Using WebCenter Content 11.1.1.6 on Solaris with search engine OracleTextSearch.

After applying the 11.2.0.4.0 patchset to the database, on top of 11.2.0.3, following error is reported when new versions of a document are checked-in:

Error 10/25/13 9:43 AM csIndexerUnExpectedError Cannot commit the transaction. JDBC Error: 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
java.sql.SQLException: 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. [ Details ]

Steps to reproduce:

1. Check in a new document (revision 1) containing a word.
2. When the document is Released, perform a Full text search on that specific word
3. Verify that the search is returning the new document
4. Check out the document
5. Add a different word in the document and check in
6. When the document is Released, perform a new Full text search on the newly added word
7. The document is not found

Changes

The 11.2.0.4.0 patchset has been applied to the database.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.