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 NOVEMBER 03, 2016

Applies to:

Oracle WebCenter Content - Version 11.1.1.6.0 and later
Information in this document applies to any platform.

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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms