This content has been marked as final. Show 3 replies
This is a known issue with an earlier version (10.2.0.1 or 10.2.0.2). This issue is not there in 10.2.0.3 onwards.
If you are on 10.2.0.1, I recommend you download the patch from http://www.oracle.com/technology/tech/semantic_technologies/index.html (click on 'software') and apply the patch. This issue should be resolved.
we are working with the following version of oracle:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi
PL/SQL Release 10.2.0.3.0 - Production
CORE 10.2.0.3.0 Production
TNS for HPUX: Version 10.2.0.3.0 - Production
NLSRTL Version 10.2.0.3.0 - Production
when we try to execute the following query
select x, kilometraje
from table (sdo_rdf_match(
'(?x :Kilometraje ?kilometraje)',
'(kilometraje > 10000)'))
we get the following error
ORA-01722: invalid number
ORA-06512: at "SYS.DBMS_SYS_SQL", line 1209
ORA-06512: at "SYS.DBMS_SQL", line 328
ORA-06512: at "MDSYS.RDF_MATCH_IMPL_T", line 235
do you have any clue???
Message was edited by:
In your case it might have something to do with the NLS_LANG environment variable. What was it set to when you loaded the data?
Try setting it to the same when you run this query also.