5 Replies Latest reply on Feb 14, 2012 7:03 PM by Matperry-Oracle

PLS-00302: component 'ADD_DATATYPE_INDEX' must be declared

916833 Feb 14, 2012 11:48 AM

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-Oracle Feb 14, 2012 1:57 PM (in response to 916833)

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
1 person found this helpful
Like Show 0 Likes(0)

Actions
2. Re: PLS-00302: component 'ADD_DATATYPE_INDEX' must be declared

916833 Feb 14, 2012 6:02 PM (in response to Matperry-Oracle)

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
Like Show 0 Likes(0)

Actions
3. Re: PLS-00302: component 'ADD_DATATYPE_INDEX' must be declared

Matperry-Oracle Feb 14, 2012 6:36 PM (in response to 916833)

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?
1 person found this helpful
Like Show 0 Likes(0)

Actions
4. Re: PLS-00302: component 'ADD_DATATYPE_INDEX' must be declared

916833 Feb 14, 2012 6:52 PM (in response to Matperry-Oracle)

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
Like Show 0 Likes(0)

Actions
5. Re: PLS-00302: component 'ADD_DATATYPE_INDEX' must be declared

Matperry-Oracle Feb 14, 2012 7:03 PM (in response to 916833)

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
Like Show 0 Likes(0)

Actions

Go to original post