5 Replies Latest reply: Feb 14, 2012 1:03 PM by Matperry-Oracle 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