This content has been marked as final.
Show 5 replies
-
1. Re: PLS-00302: component 'ADD_DATATYPE_INDEX' must be declared
Matperry-Oracle Feb 14, 2012 1:57 PM (in response to 916833)Hi,1 person found this helpful
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 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 -
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 -
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 -
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