5 Replies Latest reply: Feb 14, 2012 1:03 PM by matperry RSS

    PLS-00302: component 'ADD_DATATYPE_INDEX' must be declared

    916833
      Hello guys,
      I am trying to add a data type index to my semantic network in order to explore the Full-Text Search feature over RDF described data.
      But facing the following error I would like to ask for help if anyone can make a suggestion how can I troubleshoot that issue.
      Many thanks in advance!

      SQL> show user
      USER is "SYS"
      SQL> EXECUTE SEM_APIS.ADD_DATATYPE_INDEX('http://xmlns.oracle.com/rdf/text');
      BEGIN SEM_APIS.ADD_DATATYPE_INDEX('http://xmlns.oracle.com/rdf/text'); END;

      *
      ERROR at line 1:
      ORA-06550: line 1, column 16:
      PLS-00302: component 'ADD_DATATYPE_INDEX' must be declared
      ORA-06550: line 1, column 7:
      PL/SQL: Statement ignored
      --------

      In addition I conducted the following check:
      SQL> SELECT STATUS FROM DBA_OBJECTS WHERE OBJECT_NAME = 'SEM_APIS';

      STATUS

      VALID

      Edited by: 913830 on Feb 14, 2012 11:41 AM

      Edited by: 913830 on Feb 14, 2012 11:48 AM
        • 1. Re: PLS-00302: component 'ADD_DATATYPE_INDEX' must be declared
          matperry
          Hi,

          An older version of semantic technologies may be installed. Please post the result of the following query executed as SYS:

          SELECT * FROM mdsys.rdf_parameter;

          Thanks,
          Matt
          • 2. Re: PLS-00302: component 'ADD_DATATYPE_INDEX' must be declared
            916833
            Hi Matt, thank you for the response.
            Here is the result:

            SQL> show user
            USER is "SYS"
            SQL> SELECT * FROM mdsys.rdf_parameter;

            NAMESPACE ATTRIBUTE
            ------------------------------ ------------------------------
            VALUE
            --------------------------------------------------------------------------------

            DESCRIPTION
            --------------------------------------------------------------------------------

            COMPONENT RDFCTX
            INSTALLED
            Semantic (Text) Search component

            COMPONENT RDFOLS
            INSTALLED
            RDF Optional component for OLS support

            NAMESPACE ATTRIBUTE
            ------------------------------ ------------------------------
            VALUE
            --------------------------------------------------------------------------------

            DESCRIPTION
            --------------------------------------------------------------------------------


            COMPONENT RDFVPD
            INSTALLED
            RDF Optional component for VPD support

            MDSYS SEM_VERSION
            112

            NAMESPACE ATTRIBUTE
            ------------------------------ ------------------------------
            VALUE
            --------------------------------------------------------------------------------

            DESCRIPTION
            --------------------------------------------------------------------------------

            VALID
            • 3. Re: PLS-00302: component 'ADD_DATATYPE_INDEX' must be declared
              matperry
              Semantic technologies version 11.2.0.1.0 is installed on your system. You need release 11.2.0.2.0 or later to get the datatype indexing functionality. What database version are you using?
              • 4. Re: PLS-00302: component 'ADD_DATATYPE_INDEX' must be declared
                916833
                Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
                PL/SQL Release 11.2.0.1.0 - Production
                CORE 11.2.0.1.0 Production
                TNS for 32-bit Windows: Version 11.2.0.1.0 - Production
                NLSRTL Version 11.2.0.1.0 - Production
                • 5. Re: PLS-00302: component 'ADD_DATATYPE_INDEX' must be declared
                  matperry
                  You'll need to upgrade your database to 11.2.0.2.0 or 11.2.0.3.0 to get text indexing support. Both upgrades should be available through My Oracle Support. 11.2.0.3.0 also contains native support for named graphs.

                  Thanks,
                  Matt