This discussion is archived
5 Replies Latest reply: Feb 14, 2012 11:03 AM by matperry RSS

PLS-00302: component 'ADD_DATATYPE_INDEX' must be declared

916833 Newbie
Currently Being Moderated
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 Journeyer
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Journeyer
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Journeyer
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points