ORA-06553: PLS-306: wrong number or types of arguments in call to 'XDB$PATCHUPSCHEMA' When Running TMS_DSI_XML_SCHEMA.INSTALLSCHEMAS (Doc ID 829158.1)

Last updated on AUGUST 07, 2017

Applies to:

Oracle Thesaurus Management System - Version: 4.6.0 and later   [Release: 4.6 and later ]
Information in this document applies to any platform.
.
***Checked for relevance on 07-DEC-2010***

Symptoms

During the TMS install process, when attempting to run Step:

6.2.5 Configuring DSI Import the following error occurs:

set local=<your database>

sqlplus tms/password



SQL> exec tms_dsi_xml_schema.InstallSchemas;
BEGIN tms_dsi_xml_schema. InstallSchemas; END;


*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-06553: PLS-306: wrong number or types of arguments in call to 'XDB$PATCHUPSCHEMA'
ORA-06512: at "XDB.DBMS_XMLSCHEMA_INT", line 0
ORA-06512: at "XDB.DBMS_XMLSCHEMA", line 12
ORA-06512: at "TMS.TMSDSI_XML_SCHEMA" line 35
ORA-06512: at line 1

Steps To Reproduce:

 

This issue can be reproduced by following the TMS 4.6 Installation Guide Section below:


6.2.5 Configuring DSI Import


From the master database, enter following commands:
set LOCAL=databasename
sqlplus tms/password
exec tms_dsi_xml_schema.InstallSchemas;




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